COUTIF maybe?

[EJS]

Hello all,

I have been trying to think of variations of this function to accomplish what I am trying to. Obviously, I cant find the answer since I am coming here.

So...

I have data in columns A through Z. I want to know for every time a value in M is repeated, does the value in A have more than one variation.

Situation 1: Since FirmA is the same for each ProductA, I don't care since there are no other permutations.

A.....C.....M.....Z

A.....FirmA.....ProductA_......Z
A.....FirmA.....ProductA_......Z
A.....FirmA.....ProductA_......Z


Situation 2: In this example, since there is more than one Firm (FirmA and FirmB) for ProductB, I want the rows that have ProductB identified somehow.

A.....C.....M.....Z
A.....FirmA.....ProductB_......Z
A.....FirmB.....ProductB_......Z
A.....FirmB.....ProductB_......Z

I hope I am clear on this. Any advice would be greatly appreciated.

EJ

[MickG]

Hi This bit of code might do !
I assumed your Data starts in Row (2) and that the column with the "Firms" names is column "A". If it is Column "C", change the code variable "Col" (At Top of Code) to "-10".

Please Login or Register  to view this content.

Regards Mick

[EJS]

Excuse my ignorance but I get a debug error highlighting "End With".

Should I be including anything else?

[MickG]

Hi, Please find attached a copy of my test sheet.
Compare my layout to your own, to see what the problem might be !
Click the Button to see the highlighting.
Regards Mick

[EJS]

Thank you for your help. That is working great. I appreciate it.

EJ