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).

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.”

Profilbild adwadell2020, Kuwait.

Top-Einträge für diesen Wettbewerb

Mehr Einträge sehen

Öffentliche Anschlagtafel

  • gperja
    gperja
    • 1 Monat 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

    • 1 Monat zuvor
  • abaraiya
    abaraiya
    • 1 Monat zuvor

    Hi, look at my entry no #5 . I had done as you want. My macro will not much take much time.

    • 1 Monat zuvor
  • saif12me
    saif12me
    • 1 Monat zuvor

    Or you can upload some sample data here and arrange a contest to see the really fastest entry

    • 1 Monat zuvor
  • saif12me
    saif12me
    • 1 Monat 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

    • 1 Monat zuvor
  • ajayn01
    ajayn01
    • 1 Monat zuvor

    Could you share the sample sheet?

    • 1 Monat zuvor

Mehr Kommentare zeigen

Einstieg in Wettbewerbe

  • Veröffentlichen Sie Ihren Wettbewerb

    Veröffentlichen Sie Ihren Wettbewerb Schnell und einfach

  • Erhalten Sie zahlreiche Einträge

    Erhalten Sie zahlreiche Einträge aus der ganzen Welt

  • Vergeben Sie die Prämie an den besten Eintrag

    Vergeben Sie die Prämie an den besten Eintrag Laden Sie die Dateien herunter - ganz einfach!

Wettbewerb Veröffentlichen oder registrieren Sie sich heute!