Posted to microsoft.public.excel.misc

Exceleighton Exceleighton is offline

external usenet poster

Posts: 2

Numbering rows and skipping blanks

I'm sure this is easy...

I have a long list of names and I want to number them in the column to the
left. Some of the names are grouped and between these groups there are blank
rows. How can I number each non-blank row, increasing by 1?

Thank you!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Skipping Blanks (Again)	F. Lawrence Kulchar	Excel Discussion (Misc queries)	3	March 7th 08 10:43 PM
Skipping Blanks	F. Lawrence Kulchar	Excel Discussion (Misc queries)	1	March 7th 08 11:27 AM
copy a list and skipping blanks	Art	Excel Worksheet Functions	20	November 29th 06 03:21 PM
Skipping blanks	jmkona	Excel Discussion (Misc queries)	2	August 27th 05 01:12 AM
Paste Special Skip Blanks not skipping blanks, but overwriting...	gsrosin	Excel Discussion (Misc queries)	0	February 22nd 05 03:33 AM

All times are GMT +1. The time now is 05:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us