CODEWITHSUNDEEP
excelexcel-formulaformula
Dim24
Dim24

Reputation: 33

Is there an Excel formula for my specific scenario

Column A is ID and Column B is Product. Column C was manually generated but I am trying to find an EXCEL formula to generate Column C. My goal is to identify in column C IDs with multiple different products. So for example Row 1 and 2 have the same ID but two different products. However Row 7,8 & 11,12,13 have the same ID and same product... My challenge is to deal with scenarios like row 7,8 & 11,12,13 where ID and Product are repeated but should be counted as No. I cannot seem to find a formula and I have been trying to build something with Count IF. Following is a link to image which shows the data:Sample Data Excel

Upvotes: 1

Views: 57

Answers (1)

Spencer Barnes
Spencer Barnes

Reputation: 2877

in C2, the formula you need would be:

=IF(COUNTIFS(A:A, A2, B:B, "<>" & B2)>0, "Yes", "No")

Then copy that formula down for the rest of column C.

Upvotes: 4

Related Questions