screenname1
India
job for excel vba freelancers
- Status: Closed
- Preis: $50
- Einträge eingereicht: 7
- Gewinner: saif12me
Winner
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).
Empfohlene Fähigkeiten
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.”
adwadell2020, Kuwait.
Top-Einträge für diesen Wettbewerb
-
-
abaraiya India -
ChristensenH Denmark
Öffentliche Anschlagtafel
-
gperja
- 4 Jahre zuvor
Hello,
some sample data would be useful, just to make sure no bad assumptions are made on data.
For example, I noticed that terms like "Multiple Names", were understood by me as a "Possibly Comma separated string list of names against each record", while other developers has intended it as "Names"
Warmest- 4 Jahre zuvor
-
abaraiya
- 4 Jahre zuvor
Hi, look at my entry no #5 . I had done as you want. My macro will not much take much time.
- 4 Jahre zuvor
-
saif12me
- 4 Jahre zuvor
Or you can upload some sample data here and arrange a contest to see the really fastest entry
- 4 Jahre zuvor
-
saif12me
- 4 Jahre zuvor
I'm known for large data processing in a short execution time. All of my previous projects are Excel VBA related. Recently I won a contest among 77 entries for large data handling within short execution time. Send me details I'll give you a sample result within a short time . If you are satisfied then award me the project. Leave me a message for final discussion. Thanks
- 4 Jahre zuvor
-
ajayn01
- 4 Jahre zuvor
Could you share the sample sheet?
- 4 Jahre zuvor
Einstieg in Wettbewerbe
-
Veröffentlichen Sie Ihren Wettbewerb Schnell und einfach
-
Erhalten Sie zahlreiche Einträge aus der ganzen Welt
-
Vergeben Sie die Prämie an den besten Eintrag Laden Sie die Dateien herunter - ganz einfach!
