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
In cell A2, enter:
Formula:
Please Login or Register to view this content.
and copy down.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
@OllyXLS
Do i need to use this only formula? or along with some other..?
i tried entering this formula in B2 and copied down... all the rows were displaying no."0"
The formula was designed to go in Column A, as you suggested in your initial post, and I advised putting in cell A2, not B2.Originally Posted by inwell
If you're still stuck, try attaching your workbook so I can advise you precisely what to put where.
sorry my mistake....
it worked good.... but still one query
1.as you can see,in image,selected cell always display the formula...is it correct?
2. As you can see in image (near yahoo...) if something is entered by mistake..it remains the same... (can we do it a way so that no one could touch the formula and no one would enter anything there..by mistake too)
regards
1. Yes, the formula needs to be in column A for every row in which you may enter data. I'd suggest copying it down to the maximum number of rows you are likely to use on that worksheet.
2. You could unlock the cells in columns where you may permit data entry, and lock the cells in column A, then protect the worksheet.
thank you sir,
best wishes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks