ray:I need to sort rows by column O, lowest to highest (greater than 0), then by column A (date). Let's say the the lowest number after sorting is 5. I would like the 5 to change to 1, then take the next lowest number..hypothetically 13, and change it to 2, the next lowest..24 and change it to 3, and so on until the sort is complete and anything with a zero is under the newly sorted rows. Hope this makes sense. This is WAY above my comprehension but one of you gurus who continue to amaze us novice users can help? Thanks in advance...you ladies and gentlemen are amazing!
ray:ray:
