Serial Number on array formula.

[Umair.711]

I have a few sheets that are used for reviewing old records. (delivery challan, purchase invoice, sale invoice, etc). Each record depends on a unique number. for items description i have used array formula that is working fine. But there is a column that shows serial number of products.
item table starts from 10
Column A: serial number
COlumn B: product description
column C, d , e: quantity, rate, amount

Column A have formula (if(istext(B10), x, "")
where x is 1-17 as i have 17 rows for products.
Now as I entered array formula in all 17 rows, the serial formula is showing series even if the adjacent cell of B column in empty.
Although it contains a formula...
what formula should i use.?

[abousetta]

Try:

Please Login or Register  to view this content.

abousetta

[Umair.711]

Try:

Please Login or Register  to view this content.

abousetta

Great Abousetta.. thanks. problm solved