Hi,
How can i generate sr.no for my excel records as i go on entering them..?
when i complete my entry in the row, the next row should come up with next sr.no.

i have 4 columns(Sr/Name/Add/Phone),when i enter phone no and come to next row,it should take next serial no.

i tried =IF(B1="","",1) =IF(B2="","",A1+1) but if i leave one row blank,it shows error....(i need that if i enter 6 entries and leave 1 blank,next entry should say 7 and not 8)

regards