How to insert numbers in a column (between blank rows)

[rudolphrc]

I have an excel document with 8000 + rows with 23 columns and desire to populate the UID column with a number with everything associatedwith that item (between row breaks). What formula can I use to populate the UID column automatically insequential order?(I’ve populated thedata shown below).

Column 1 UID, Column 2 ser #, Column 3 Item

UID #	PKG_ID	DESCRIPTION
1	BOXRBATTERY	BATTERY STORAGE RM
1	C115529117	BATTERY (K)
1	C082732718	BATTERY (4)
1	C115529133	BATTERY (B)
1	C115529164	BATTERY (3)
2	9480968	TRUCK
2	PO9480968	RADIO
3	9480967	TRUCK,UTILITY
3	PO9480967	RADIO
4	9480965	TRUCK
4	PO9480965	RADIO
4	5127431	FLOODLIGHT
4	5127809	GENERATOR
5	9480963	TRUCK
5	PO9480963	RADIO
6	3460954	TRUCK
6	PO9480954	RADIO
6	9504639	CLEANER,STEAM
7	6770953	TRUCK
7	PO9480953	RADIO
7	5126126	FLOODLIGHT
7	5127159	GENERATOR

<tbody>
</tbody>

 

[footoo]

=if(b3="","",if(b2="",a1+1,a2))

 

[kvsrinivasamurthy]

Assuming UID starts from B2.
In B2 then copied down.

=IF(A2="","",Sum(B1)+1)

 

[rudolphrc]

In the data I provided there is a header row and the first data field would be (A2) which I have populate the number 1 requesting after every blank row then the number would be (2) etc...... in the data set here the blank rows are (A7), (A10) etc....

 

[jtakw]

Hi,

Based on your sample, formula in A2 copied down:

Book1
	A	B	C
1	UID	ser #	Item
2	1	BOXRBATTERY	BATTERY STORAGE RM
3	1	C115529117	BATTERY (K)
4	1	C082732718	BATTERY (4)
5	1	C115529133	BATTERY (B)
6	1	C115529164	BATTERY (3)
7
8	2	9480968	TRUCK
9	2	PO9480968	RADIO
10
11	3	9480967	TRUCK,UTILITY
12	3	PO9480967	RADIO
13
14	4	9480965	TRUCK
15	4	PO9480965	RADIO
16	4	5127431	FLOODLIGHT
17	4	5127809	GENERATOR
18
19	5	9480963	TRUCK
20	5	PO9480963	RADIO
21
22	6	3460954	TRUCK
23	6	PO9480954	RADIO
24	6	9504639	CLEANER,STEAM
25
26	7	6770953	TRUCK
27	7	PO9480953	RADIO
28	7	5126126	FLOODLIGHT
29	7	5127159	GENERATOR
Sheet545

Cell Formulas
Range	Formula
A2	=IF(B2="","",IF(N(A1),A1,MAX(A$1:A1)+1))