VBA increment number sequence based on 2 cell values

[NormChart55]

Hello - I am in need of a macro number sequence of files so that I can separate.

I have data headers in column C4-H4 and all the data will be located in C5:H50000 depending on how much data there is (that changes). I am needing to add a number sequence in Column B that goes in increment based on C (address) and H (reference) data. Example below. In the example below, I would want the sequence for first 3 lines to be 1/1/2 because line 3 the reference changes. Lines 4/5 would be 1/2 because the 5th line reference changes. Basically if reference changes compared to the address then it should be a new number sequence for that only so I can filter out the number of separate pages. I hope that makes sense. Thanks for any and all help you can provide.

Address	Data	part	Quantity	vendor	Reference
AAA					XXX
AAA					XXX
AAA					XXY
BBB					YYY
BBB					YYX

 

[Joe4]

That example does NOT look sorted to me.
I am thinking a two-level sort. Sort by Code field as the primary sort, and Reference field as the Secondary sort.

 

[Akuini]

Could the data be like this?

Book1
	A	B	C	D	E	F	G
1	Code					Reference	Expected sequence
2	JYT					XXX	1
3	JYT					XXX	1
4	JYT					XXY	2
5	JYT					XXX	?
Sheet3

if so, what should be the result of the last row?

 

[kevin9999]

Deleted - need more work.

 

[kevin9999]

Does this come close?

NormChart55.xlsx
	B	C	D	E	F	G	H
4	SEQUENCE	Code					Reference
5	1	JYT					XXX
6	1	JYT					XXX
7	2	JYT					XXY
8	1	JGD					XXX
9	1	JGD					XXX
10	2	JGD					XXY
11	2	JGD					XXY
12	3	JGD					XXX
13	1	JZX					XXX
14	1	JZX					XXX
15	1	JZX					XXX
16	1	JYT					XXX
17	2	JYT					XXY
18	3	JYT					XXZ
Sheet1

Cell Formulas
Range	Formula
B5:B18	B5	=IF(C5<>C4,1,IF(AND(C5=C4,H5=H4),B4,IF(AND(C5=C4,H5<>H4),B4+1)))