Exclusive Matching data in large excel file (+400 lines)
Budget: $250 – $750 AUD
I am looking for a freelancer to help me with my project of matching data in a large excel file with over 400 lines. The key criteria for matching the data is an exact match. I am open to suggestions for a specific method or tool for matching the data. The output should be delivered in a separate file with only the matched data.
Ideal skills and experience:
- Experience with data matching in excel
- Knowledge of various tools and methods for matching data
- Attention to detail to ensure accuracy in matching the data
- Proficient in excel to deliver the output in the required format.
The purpose is to make the data matching work in a large excel file
i can not do myself this task , cause i think my computer is not enough powerful or may be it has to be done with something else than excel
(with normal number of lines, this function is 30 seconds to execute...but the file is very large)
I will provide you with an excel / open office document, with 330 000 lines
Source Data (328 000 lines)
Column A : Hotel Name
Column B : Hotel Url
Column C : Photo Url
To be matched with other set of data
Column E : ID (123 000 lines)
Column F : Hotel Name
Column G : Hotel Url
Column H : output (formula =RECHERCHEV(G1;B$1:C$400000;2;0)) : i want in this cell a matching between column G and B (if data from column G found in column B, then return column C), returning as a result column C. I processed the good formula for the first 50 lines...but can not extend this due to performance reasons
here enclosed rough sample data
Ideal skills and experience:
- Experience with data matching in excel
- Knowledge of various tools and methods for matching data
- Attention to detail to ensure accuracy in matching the data
- Proficient in excel to deliver the output in the required format.
The purpose is to make the data matching work in a large excel file
i can not do myself this task , cause i think my computer is not enough powerful or may be it has to be done with something else than excel
(with normal number of lines, this function is 30 seconds to execute...but the file is very large)
I will provide you with an excel / open office document, with 330 000 lines
Source Data (328 000 lines)
Column A : Hotel Name
Column B : Hotel Url
Column C : Photo Url
To be matched with other set of data
Column E : ID (123 000 lines)
Column F : Hotel Name
Column G : Hotel Url
Column H : output (formula =RECHERCHEV(G1;B$1:C$400000;2;0)) : i want in this cell a matching between column G and B (if data from column G found in column B, then return column C), returning as a result column C. I processed the good formula for the first 50 lines...but can not extend this due to performance reasons
here enclosed rough sample data