Creating Serials and Searching Above

[glenbethel]

Thanks ahead of time Excel gurus.. Effectively I have a spreadsheet where I have columns that allow the selection of some info and then based on that info I want the function to come along to a certain cell.. search upwards in the column until it finds the last non-empty cell ... From there I am simply going to increment that cell by one to create my ascending serial numbers. I've also put a pic in if that helps explain what i want to do .

 

[BSALV]

Vinzo01.xlsb
	D	E	F	G
3				202200000
4
5	04
6	04
7	03			202200001
8	03			202200002
9	02
10	01
11	07
12	02
13	10
14	08
15	05
16	10
17	06
18	10
19	08
20	06
21	07
22	07
23	08
24	08
25	07
26	04
27	03			202200003
28	08
29	03			202200004
30	01
31	04
07.01.22

Cell Formulas
Range	Formula
D5:D31	D5	=TEXT(RANDBETWEEN(1,10),"00")
G4	G4	=IF(D4="03",AGGREGATE(14,6,$G$1:G3/($D$1:D3="03"),1)+1,"")
G5:G31	G5	=IF(D5="03",MAX($G$1:G4)+1,"")

 

[BSALV]

Vinzo01.xlsb
	D	E	F	G
3				202200000
4
5	08
6	05
7	10
8	01
9	09
10	03			202200001
11	08
12	04
13	07
14	08
15	10
16	02
17	08
18	08
19	07
20	07
21	01
22	07
23	08
24	04
25	10
26	06
27	02
28	10
29	01
30	05
31	07
07.01.22

Cell Formulas
Range	Formula
D5:D31	D5	=TEXT(RANDBETWEEN(1,10),"00")
G5:G31	G5	=IF(D5="03",MAX($G$1:G4)+1,"")

 

[glenbethel]

Vinzo01.xlsb
	D	E	F	G
3				202200000
4
5	08
6	05
7	10
8	01
9	09
10	03			202200001
11	08
12	04
13	07
14	08
15	10
16	02
17	08
18	08
19	07
20	07
21	01
22	07
23	08
24	04
25	10
26	06
27	02
28	10
29	01
30	05
31	07
07.01.22

Cell Formulas
Range	Formula
D5:D31	D5	=TEXT(RANDBETWEEN(1,10),"00")
G5:G31	G5	=IF(D5="03",MAX($G$1:G4)+1,"")

Vinzo01.xlsb
	D	E	F	G
3				202200000
4
5	08
6	05
7	10
8	01
9	09
10	03			202200001
11	08
12	04
13	07
14	08
15	10
16	02
17	08
18	08
19	07
20	07
21	01
22	07
23	08
24	04
25	10
26	06
27	02
28	10
29	01
30	05
31	07
07.01.22

Cell Formulas
Range	Formula
D5:D31	D5	=TEXT(RANDBETWEEN(1,10),"00")
G5:G31	G5	=IF(D5="03",MAX($G$1:G4)+1,"")

You kind Sir/Madam, are a legend !!!