I'm having trouble with this formula. I need to count only if range1 and range2 create a unique combination. range1 is text and range2 is number.

both ranges will have countless duplicates.

I could do this with concatenate, but I would prefer to know the proper way to do this before creating new ranges to work on.

Thank you for any help or ideas beforehand.

Justin