• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Conversion Help [SOLVED]

    Thanks SirJB7!!!! This will help me out work.
  2. D

    Conversion Help [SOLVED]

    Hey SirJB7, Original formula had 2 =IF(ROW() I removed one of them and it is working fine now! Next problem I have is that I usually get larger lists of data that needs to be converted like this. Sometimes 500,000 rows. Can the formula be edited so I can convert a larger amount of data...
  3. D

    Conversion Help [SOLVED]

    Hey SirJB7, Column C looks like this now: 3.1 4.1 9.1 11.1 Column D gives me a error when I input the formula: "Your formula is missing a parenthesis--) or (.
  4. D

    Conversion Help [SOLVED]

    Thanks SirJB7, This is what Im getting in Columns C and D now. Its a little off 3 48088 4 48088 9 48088 11 48098 48098 48098 48098 48098 48096 48096 48329 48088 is correct, others are not.
  5. D

    Conversion Help [SOLVED]

    I hoping someone can help me convert two columns of data into one column of data. I have tried a reverse pivot table, but I did not get the results I was looking for. This is what I have: 48088 3 48098 1 48096 5 48329 2 This is what I need: 48088 48088 48088 48098 48096 48096...
Back
Top