Automatic numbering

ilkks · #1 05-12-2011, 11:13 PM

Example Excel-sheet attached.

There should be ascending numbering at column E. How to make blank cell instead of space " "?

And 'Total price' should sum up every cell next to text "Price", but that formula is also failing.

OTPM · #2 05-13-2011, 12:47 AM

Quote:

Originally Posted by ilkks

Example Excel-sheet attached.

There should be ascending numbering at column E. How to make blank cell instead of space " "?

And 'Total price' should sum up every cell next to text "Price", but that formula is also failing.

Hi Ilkks
I am not sure if this is what you want but I have modified the formulae slightly. What will happen now is if you insert extra rows against each product the numbering will still run ascending.
If this is not what you want please provide more info and I will see what I can do.
Tony

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic Formatting for whole row	Bacchanal Promotions	Excel	2	03-19-2011 05:12 AM
Automatic Chapter Numbering	arainyplace	Word	1	08-11-2010 07:39 AM
automatic requirement numbering with change detection	stijnos	Word	0	05-13-2009 12:10 AM
Automatic bcc	nickynono	Outlook	0	06-13-2006 02:30 PM
Automatic email pop up	anitadzebic	Outlook	4	03-09-2006 08:33 PM