Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 05-13-2011, 12:47 AM
OTPM OTPM is offline Automatic numbering Windows 7 32bit Automatic numbering Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by ilkks View Post
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
Attached Files
File Type: xlsx Copy of ExcelSheet(1).xlsx (10.7 KB, 19 views)
Reply With Quote
 



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 numbering 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 numbering Automatic email pop up anitadzebic Outlook 4 03-09-2006 08:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft