job for excel vba freelancers
- Status: Closed
- Preis: $50
- Einträge eingereicht: 7
- Gewinner: saif12me
Kurzbeschreibung des Wettbewerbs
pls respond only if you are an expert in excel vba/macros and know how to solve the problem successfully. This is not a trial and error job.
i have a workbook that contains 500,000 rows and 3 columns (multiple names in column A, value in column B, and multiple addresses in column C) and i need to: (1) extract names from column A and list unique instances of names alphabetically in column I (one name one cell) and (2) extract unique country names from column C and paste them in order in the corresponding cells in column H (one cell could have multiple unique names, e.g., cell H1: India; UAE; UK). Some cells could be empty.
**the winner excel vb code should finish processing of the records and pasting results in relevant cells in around one minute; the code need to be delivered ASAP.**
(p.s. creating a loop and writing the values one cell at a time is not the sought after solution).
Feedback vom Arbeitgeber
“Saif is highly professional and dedicated to his work. The best freelancer I had worked with so far. Highly recommended for Excel/VBA jobs.”