ExcelBanter - IsBlank( ) feature

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IsBlank( ) feature (https://www.excelbanter.com/excel-discussion-misc-queries/126724-isblank-feature.html)

FARAZ QURESHI

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

JE McGimpsey

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

FARAZ QURESHI

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

All times are GMT +1. The time now is 08:52 PM.