| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to increment sequence only if text in a particular cell
Hi,
I'm new to this, and not sure how to do this, I'd like to increment a field by one only if there's text in a particular cell. This is what I have, so I'm trying to write a formula that automatically populates column A...this is what I have tried =IF(C4<"","Test_"&TEXT(ROW(A1),"000"), "") --- but this formula increments even when no text in B, so I end up with a value of Test_003 in A3, where I need to have Test_002 A B 1 Test_001 some text 2 3 Test_002 more text Any advice would be greatly appreciated!! :) Cheers, Mills |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| increment cell reference in a formula | Excel Worksheet Functions | |||
| Need formula to increment cell reference every 8th row | Excel Discussion (Misc queries) | |||
| Capturing a word sequence as part of a text in a spreadsheet cell | Excel Worksheet Functions | |||
| how to auto increment cell location within formula | Excel Worksheet Functions | |||
| Formula for copying a sequence for every 8th cell | Excel Worksheet Functions | |||
Threaded Mode
