Posted to microsoft.public.excel.programming

MartinK[_2_] MartinK[_2_] is offline

external usenet poster

Posts: 3

Sequential number within excel

Using Formulas it Would look something like this:
Columns D
=IF(ROW()=2;1;IF(A2<"";D1+1;D1))
Column E
= IF(ROW()=2;1;E1+1)
Column F
= D2&"."&E2

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
I need to Sequential number an excel 2000 template.	Jdean	Excel Programming	2	March 9th 06 06:56 PM
need help w/sequential invoice number on excel worksheet	Landfillpark	Excel Worksheet Functions	1	March 3rd 06 11:48 PM
How do I Auto Number a field in Excel - sequential PO#	Melinda	Excel Worksheet Functions	1	November 30th 05 09:00 PM
Can you automatically insert next sequential number in an excel fo	jo_9865	Excel Discussion (Misc queries)	2	August 4th 05 10:58 PM
unique sequential number excel 2000	Ches	Excel Discussion (Misc queries)	0	May 13th 05 10:55 PM

All times are GMT +1. The time now is 10:55 AM.

About Us

"It's about Microsoft Excel"