Matching 3 separate excel values to the closest 3 values in a list
£10-20 GBP
Suoritettu
Julkaistu yli 5 vuotta sitten
£10-20 GBP
Maksettu toimituksen yhteydessä
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
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 am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 reputation points.
Proposed Milestones
£12 GBP - Completion of the project
I had one question about the calculations though which we can certainly clarify over personal chat.
Best
Sourabh
£12 GBP 1 päivässä
5,0 (170 arvostelua)
6,3
6,3
26 freelancerit tarjoavat keskimäärin £15 GBP tätä projektia
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
£15 GBP - Lets start. Having a team of Professionals. We provide high quality work with accuracy.
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
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
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 - Complete
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 Milestones
£18 GBP - 1
Provide me complete details of the work and I will get this done to you.
Thanks!
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, Statistical Analysis
Proposed Milestones
£13 GBP - default
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 budget and time with quality.
Proposed Milestones
£10 GBP - will complete the task.
Please come on chat for more details.
Awaiting your response.
Thank you.
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.
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
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 that can 100% correctly predict the integer. I have more than 4 years experience on Python coding.
Proposed Milestones
£13 GBP - Full project complete
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 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.
Proposed Milestones
£18 GBP - Before submitting the work, then take the Milestone Payments
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
compare and analyze data, find the closest number as required.
Relevant Skills and Experience
excel experience and VBA
Proposed Milestones
£15 GBP - paypal
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 entry and 6 month experience
Proposed Milestones
£10 GBP - Please sir make milestone for secure money
I am taking few money because I am new but I provide high quality of work