Forum Discussion
For all rows that are same in first column, compare rows in second column
I am looking for help writing a formula. I need my formula to look at the values in column A, and for all rows with the same value in column A then compare the values in column AC to tell me if ...
As variant
=LET(
ids, A2:A12,
type, B2:B12,
id, UNIQUE(ids),
types, IF(COUNTIFS(ids,id,type,"Salary")=COUNTIFS(ids,id), "Salary", "Mix"),
IF({1,0}, id, types))