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 ...
KimberlyHoldiman Now, if this is just a one-time exercise, you could create a pivot table counting the number of occurrences for Hourly and Salary for each employee. Then, a "quick-and-dirty" COUNT function can determine which employees have entries in both or only one of the categories.
An example is attached.