LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Auto number Non null values

Column A contains row numbers ONLY if there is a corresponding value (text)
in column B.
Is there a function that will do this for me? It needs to re-increment when
a row is added in the middle, much like numbered bullets reconfigure. Right
now, the best I can do is apply a row number whether there is a value there
or not. All I want is an incremented counter in column A for any row in
which I enter a text value in column B. I would appreciate ANY help!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Trouble with null values Tazzy via OfficeKB.com Excel Worksheet Functions 6 December 6th 07 11:23 AM
auto data source, removing null OTWarrior via OfficeKB.com Charts and Charting in Excel 2 July 3rd 07 04:56 PM
Null values need to be replaced Hey Excel Discussion (Misc queries) 3 February 7th 07 03:22 AM
sum if - null values DC Excel Discussion (Misc queries) 1 October 16th 06 05:56 PM
Auto-prompt/complete (?) function for number values Raj Mazumdar Excel Discussion (Misc queries) 1 January 10th 06 06:49 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"