Results 1 to 1 of 1
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Excel formula or macro for string of numbers

    Hello - I have a sheet (before) that has a list of numbers. I need it to look like the after sheet.

    The numbers in COL A have a .1 and/or a .2. There are usually a pair of numbers like 5.1 and 5.2. There are some, however, that are not "paired", like 13.1 - there is no 13.2.

    If there is a .1 then I need the COL B number to go in COL C. If the next row has the same number but with a .2 in it, then I need the number in COL B to be put in COL D but in the row above - see the after sheet in cell D5. I also need COL A to only have the whole number with no decimal in it.

    Thank you for the help.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts