|
EXCEL GENIUSES PLEASE HELP!!!!!
Posted 6/27/2010 10:47:49 AM by BellyBlessings Hi all, I filtered an excel sheet to show Unique Records only. Now I want to auto number them regardless if a record was removed - so if row 2 was removed - I still want the numbers to read 1,2,3... but it is numbering them 1,3,4,5... it is accounting for the fiiltered out record - which I don't want it to do... any idea how to make it do what I need it do? Basically when I turn the auto filter off - I want it to show a blank cell where there was no number assigned |