Forum Discussion
Excel number ordering
Hi Everyone, My name is Dean, I've spent the last few weeks struggling to learn excel and now i need a little help if possible... Does anyone know of way to quickly number each name as I've d...
As a variant:
Since your dates are all properly formatted, consider this formula in A3 and fill it all the way down.
=IF(ISNUMBER(B3),"",N(A2)+1)The N(..) part sees to it that you don't get an error when you add 1 to a cell with "". You will loose the formatting in the first column (blue color and borders), but that can easily be fixed by "painting" the format of any of the other columns on to A and change back the alignment and number formatting to your liking. Your revised file is attached.
You guys are absolute legends and i can't thank you enough,
This is absolutely super,
Thank you so so much 🙂
Dean