Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to insert serial numbers to rows?
suppose i have a worksheet in which i have some data in col B with a header on B1.
there are blank rows in between data.i want to give serial numbers to col A irespective of the fact that whether it has data on its right side or it is a blank one. i put 1 in col A2. i put =then i click on A2 and then input +1. then i press f5 and put A24 pressed the shift key and pressed enter. then i pressed control D.as a result , i get serial numbers from 1 to 24 in col A. (suppose there are only 10 data rows and others are blanks.) now i want to eliminate the blank rows keeping the serial numbers(in col A) of the data rows in place. now i enter =COUNTA(B2) in col C.i copy the formula to the last row of data. i get 1 against data rows and zero against blank rows. now i apply autofilter to col A1 select zero in col C. i get all blank rows together. i delete them. now i get the data without the blank rows. the problem i face is that the serial number in col A has disappeared. it says problem with the cell reference. now let me ask whether it is possible to do this task with the serial numbers in place( of course the numbers will be minus the blank rows,like 1,2,4,7,12..... i don't mind) ----------------------------- A B C ----------------------------- SL.NO TITLE ----------------------------- 1 abc 1 2 wett 1 3 0 4 jkhghj 1 5 0 6 0 7 rloljo 1 8 0 9 0 10 fddde 1 11 0 12 rderu 1 ------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
serial numbers with hidden rows | Excel Worksheet Functions | |||
to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Renaming Sequential Rows to create serial numbers | Excel Worksheet Functions | |||
how do I insert an ' in front of many rows of numbers? | Excel Programming | |||
how do I insert an ' in front of many rows of numbers? | Excel Discussion (Misc queries) |