| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IsBlank( ) feature
Can somebody help me out with the following trouble:
I want to have an IsBlank type of feature and want the cell "A2" to be reflecting a serial number (e.g. A1 + 1), but ONLY and ONLY if ANY of the other cells in row 2:2 is not blank. In other words, once you enter any data in the corresponding row, the cell in column A:A records a new serial number. MACROS or any other means are most welcome. THANX |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IsBlank( ) feature
One way:
A2: =IF(COUNTA(B2:IV2),A1+1,"") Copy down as far as desired... In article , FARAZ QURESHI wrote: Can somebody help me out with the following trouble: I want to have an IsBlank type of feature and want the cell "A2" to be reflecting a serial number (e.g. A1 + 1), but ONLY and ONLY if ANY of the other cells in row 2:2 is not blank. In other words, once you enter any data in the corresponding row, the cell in column A:A records a new serial number. MACROS or any other means are most welcome. THANX |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IsBlank( ) feature
XCLENT!!!
Thanx Pal "JE McGimpsey" wrote: One way: A2: =IF(COUNTA(B2:IV2),A1+1,"") Copy down as far as desired... In article , FARAZ QURESHI wrote: Can somebody help me out with the following trouble: I want to have an IsBlank type of feature and want the cell "A2" to be reflecting a serial number (e.g. A1 + 1), but ONLY and ONLY if ANY of the other cells in row 2:2 is not blank. In other words, once you enter any data in the corresponding row, the cell in column A:A records a new serial number. MACROS or any other means are most welcome. THANX |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List feature in XL 2003 | Excel Discussion (Misc queries) | |||
| synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
| Autosave feature in Excel 2003 | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
Hybrid Mode
