Auto numbering of rows basing on true values

[masud8956]

Hi,

I have a table where I import data from other worksheets. Column A is for row numbers. I have other data in columns B, C and D.

A3 B3 C3 D3
1 ...x...y...z
2....p...q...r

I need a formula to populate column A automatically with chronological row numbers when there is data in either B/C/D.

Anyone?

 

[footoo]

In either way
U can use the formula =if(B2="","",A1+1) Drag for respective cells also.

That formula is not appropriate. The OP requires all cells in a row from C:Q to be empty or contain ""
Also it will return, after a blank, the number 1 instead of the next sequential number