Results 1 to 1 of 1
2012-10-17, 14:14 #1
- 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.