Tamamlanmış

Matching 3 separate excel values to the closest 3 values in a list

I have 2 lists in excel. The first list contains 3 columns with random numbers such as below;

0.381323, 0.371693, 0.246983

The second list also contains 3 random numbers and an integer for example;

66461, 0.382561083, 0.371066183, 0.246372737

I need to find the closest match to all 3 numbers from the first list in the second list and return the integer beside them.

I have attached the file as an example.

Please do not bid without looking at the file.

thanks

Beceriler: Data Analytics, Veri Bilimi, Excel, Matematik, İstatistiksel Analiz

Daha fazlasını gör: excel permutation list values, excel pricelist list, excel products list, convert excel contact list labels, excel display variable number values, excel price list sample, excel file list counties, vba split separate excel, excel formulas list, excel price list, vba excel add list references, excel copy list, excel customer list, excel mailing list, excel spreadsheet copy paste values

İşveren Hakkında:
( 7 değerlendirme ) coalisland, United Kingdom

Proje NO: #17410393

Seçilen:

sourabhg98

Hey there, I did check the file you uploaded and checked your examples and the red highlighted rows in list 2. I will provide you a fully automated macro or formula whatever you wish. Relevant Skills and Experience I Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% GBP
(81 Değerlendirme)
5.3

Bu iş için 30 freelancer ortalamada £16 teklif veriyor

DeepSyaal

Lets start. Having a team of Excel Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements? Relevant Skills and Experience Excel Proposed Milestones £ Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(198 Değerlendirme)
6.4
Anamika97

I can do this job efficiently,i have more than 10 years of experience in this field, please give me a chance to work with you. Thanks Relevant Skills and Experience data entry Proposed Milestones £13 GBP - full

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(190 Değerlendirme)
6.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(148 Değerlendirme)
6.2
MdAlamgirHoosain

Dear Sir, I have gone through your job-posting and become very eager to do the [login to view URL] I have a good knowledge in the field that you mentioned in your job's skill. Relevant Skills and Experience I am a hard-worke Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(146 Değerlendirme)
6.0
usmnwaraich

Hi, Please come to chat and let me know that you want to get the entries for those 16 in the first list? Relevant Skills and Experience I am expert in excel and can do this job according to requirements. Proposed Mil Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(18 Değerlendirme)
4.7
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 7 years usi Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(30 Değerlendirme)
4.8
ScareCrow01

Not a hard thing Relevant Skills and Experience Excel Proposed Milestones £18 GBP - Full

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(19 Değerlendirme)
4.2
lightingdavid

Excel Expert Relevant Skills and Experience Hello. I have good skills in Excel. I have read your project description carefully and i can do it immediately. Contact me please. Thanks. Proposed Milestones £21 GBP - Com Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(12 Değerlendirme)
4.8
prasannjeetp

It is required to create a vba programme that will match columns and fetch result on given condition. Relevant Skills and Experience I am an excel expert with very good knowledge of VBA. I can do this job in minimum b Daha Fazla

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(40 Değerlendirme)
4.5
nousinalam2017

Dear Sir I have read you job posting and became very interested to do this task.I have good experience in this [login to view URL] ready to start now. Relevant Skills and Experience I am perfect for this [login to view URL] award me Pr Daha Fazla

in %bids___i_period_sub_35% gün içinde11%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
3.4
nishantha041

Hi, I just start to work on this,will update once solved. Thank you Relevant Skills and Experience excel Stay tuned, I'm still working on this proposal.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(4 Değerlendirme)
2.9
abdulkarim97

Hi.. I saw your project and want to help with it if you will accept my proposal.I can give you an assurance of a good job. Thanks. Relevant Skills and Experience Data Analytics, Data Science, Excel, Mathematics, Stati Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(7 Değerlendirme)
2.8
gregorybliault

Hello there I can quickly make you a script for you, I just took a look at the sheet Please contact me Relevant Skills and Experience Python Excel sheets related libraries Proposed Milestones £13 GBP - delivery

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
2.7
MahtabShaan

As you have already provided a sample file, I can implement a simple python code to solve this. So, I do not need anything more. Relevant Skills and Experience I can guarantee you that I can deliver you a simple code Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
1.6
Ut1262001

Hey My name is uttam kumar And I live in india My skils is expert in data entry, photoshop, copy typing, transaction etc I am new but I provide high quality of work Relevant Skills and Experience Mater in data en Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
tyragu

compare and analyze data, find the closest number as required. Relevant Skills and Experience excel experience and VBA Proposed Milestones £15 GBP - paypal

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
rohitkumartech

i complete your work Stay tuned, I'm still working on this proposal.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0
Kaushiks662

Well Knowledge with excel Relevant Skills and Experience well known knowledge about excel Proposed Milestones £10 GBP - 5 Additional Services Offered £1 GBP - Can do future work at a discount

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde18%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Dexpertbd

I am an expert of Ms- Word, Ms- excel and my typing speed is very good. I have 4 years’ experience as a data entry operator and also I do proofreading and internet research. Relevant Skills and Experience I am an expe Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)
0.0