ashleyuk1984

08-01-2019, 09:39 AM

Hi,

I have a list of Descriptions and Package Types... I'm trying to give them distinct numbers based on the criteria....

Similar to this:

AA = 1

BB = 2

CC = 3

AA = 1

AA = 1

BB = 2

I hope that makes sense.

But my criteria is based across two columns (description and package type). I have what looks like a working formula for the most part, but for some reason one of the rows isn't calculating correctly?? And I can't work out why?

24726

=IF(B3>0,IF(COUNTIFS(B$3:B3,B3,C$3:C3,C3)=1,MAX(D$2:D2)+1,VLOOKUP(B3,B$2:D2,3,0)),"")

I'm wondering if my formula could be either fixed, or if there are any other formulas that could essentially do the same job, if not better? I'm probably over thinking this!!

I've attached a sample workbook.

24727

Thank you so much!

I have a list of Descriptions and Package Types... I'm trying to give them distinct numbers based on the criteria....

Similar to this:

AA = 1

BB = 2

CC = 3

AA = 1

AA = 1

BB = 2

I hope that makes sense.

But my criteria is based across two columns (description and package type). I have what looks like a working formula for the most part, but for some reason one of the rows isn't calculating correctly?? And I can't work out why?

24726

=IF(B3>0,IF(COUNTIFS(B$3:B3,B3,C$3:C3,C3)=1,MAX(D$2:D2)+1,VLOOKUP(B3,B$2:D2,3,0)),"")

I'm wondering if my formula could be either fixed, or if there are any other formulas that could essentially do the same job, if not better? I'm probably over thinking this!!

I've attached a sample workbook.

24727

Thank you so much!