EXCEL GENIUSES PLEASE HELP!!!!!

Posted By Message

BellyBlessings
LIF Adolescent

Member since 8/08

574 total posts

Name:

EXCEL GENIUSES PLEASE HELP!!!!!

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

Posted 6/27/10 10:47 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

luvsun27
Check out my cool glasses

Member since 5/05

8135 total posts

Name:
Kim

Re: EXCEL GENIUSES PLEASE HELP!!!!!

I would take the filtered records and copy them to a new sheet. Highlight everything in the current sheet and hit <cntrl>+G and choose the "special" button. On the bottom right side choose "visible cells only". Paste to another sheet. Now use the auto number.

Posted 6/27/10 4:47 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Can a Word doc be merged into an Excel doc? NFT Smileyd17 7/9/09 1 Families Helping Families ™
Excel Wizards... nevermind! Lucky09 5/10/08 0 Families Helping Families ™
can you format a table in Word, the same way you can in Excel? randella 6/13/07 3 Families Helping Families ™
my excel freaking crashed- I lost 2 hours worth of work! Beth 1/24/07 8 Families Helping Families ™
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
PowerPoint and Excel.. LBG30 10/18/05 6 Families Helping Families ™