Excel Data Conversion Specialist

  • Status: Pending
  • Prize: $50
  • Entries Received: 43
  • Winner: MimiFL

Contest Brief

I'm looking for an Excel expert to help with data conversion tasks.

Key Responsibilities:
- Converting text data to numerical values in Excel.
- Converting numerical data to text representations.

Requirements:
- Proficient in Excel, particularly in data conversion.
- Experience with converting text data into numerical values and vice-versa.
- Strong understanding of data representation.

Please share your relevant experience. Share timers of the process.
999 Rows x 100 Phase 1
999 Rows x 1000 Phase 2
999 Rows x 10000 Phase 3

Looking for the fastest performing one. But top performers would still be in contact for possible projects.
Due to computer variations I would need to test on my end for performance. You can share a screenshot of yours prior of the timed performance. The file for my testing and actual time will be done on my end.

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • saw2up
    saw2up
    • 2 days ago

    Unfortunately, the actual values ​​of phase 1, phase 2, phase 3 of the winner in the competition have not been announced.

    • 2 days ago
  • iworship2006
    Contest Holder
    • 1 week ago

    Scores are being finalized at this time. Appreciate the patience.
    If already given a score. You will get a new score with my new system. The score will now be final
    and conclude this contest for the top entries.

    • 1 week ago
  • iworship2006
    Contest Holder
    • 1 month ago

    I have updated a smaller sample file how the A-J are unique digits. To ensure the data is transferred properly to the bigger table.
    I need the following displayed on your entry.
    1. Phase 1 Test Run performed by yourself using AA-JJ
    2. Phase 2 Test Run performed by yourself using AAA-JJJ
    3. Phase 3 Test Run performed by yourself using AAAA-JJJJ

    Show the time it takes to process each phase. I will be testing top Phase 3 Performers.

    RowsXColumns
    Phase 1 = 1000x100
    Phase 2 = 1000x1000
    Phase 3 = 1000x10000

    • 1 month ago
    1. Farrukh Saeed
      Farrukh Saeed
      • 4 weeks ago

      check #47

      • 4 weeks ago
    2. saw2up
      saw2up
      • 2 weeks ago

      Phase 1 = 1000x100 Counter= 5.04688
      Phase 2 = 1000x1000 Counter= 42.79297
      Phase 3 = 1000x10000 Counter= 521.83203

      • 2 weeks ago
  • saw2up
    saw2up
    • 2 weeks ago

    The "Upload an Entry" button under the competition price has disappeared.
    I can't upload my solution.

    • 2 weeks ago
  • Farrukh Saeed
    Farrukh Saeed
    • 1 month ago

    check my entry #32

    • 1 month ago
    1. Farrukh Saeed
      Farrukh Saeed
      • 1 month ago

      and #33

      • 1 month ago
  • A4036133
    A4036133
    • 1 month ago

    Thanks for checking my entry #26

    • 1 month ago
  • ismailhossainbd1
    ismailhossainbd1
    • 1 month ago

    please check my entry #21

    • 1 month ago
  • evansun98
    evansun98
    • 1 month ago

    Can I use Python ?

    • 1 month ago
    1. evansun98
      evansun98
      • 1 month ago

      Only use VBA?

      • 1 month ago
  • hellensmith1
    hellensmith1
    • 1 month ago

    Its just a matter of being accurate and use of combinations. I can do this

    • 1 month ago
  • zafarfarooq612
    zafarfarooq612
    • 1 month ago

    I am an Excel expert, I can do this.

    • 1 month ago
    1. zafarfarooq612
      zafarfarooq612
      • 1 month ago

      Sir we'll prepare a VBA code for this, this is the shortest way to complete this type of Tasks.
      In the VBA coding, we'll generate codes for each combination of 2 letters, 3and letters, and this Will be the most accurate way to generate all possible combinations of unlimited letters.

      • 1 month ago
    2. zafarfarooq612
      zafarfarooq612
      • 1 month ago

      In the manual process there may be a chance of missing combinations, but coding we'll generate accurately.

      • 1 month ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!