Forum Discussion
SUMIF or Vlookup - count/sum the number of times based on unique values?
I would like to create a formula that counts how many times a condition appears based dates. For example in my example below, I want to the result to be 2 since Bob appears on separate dates 2 H...
Updated file.
FREQUENCY can make this happen but the best solution at this point is the simplest. Using Distinct Count in a pivot table.
To make Distinct Count available in the value field options the pivot source has to be tabled and added to the data model.
Sample attached.
I'm afraid I left out some important info. Bob will not be the only person I'm looking for. Basically, this is to track how many times someone has been retrained.
Bob has made 8 errors and has been retrained twice on them on separate dates
Sue has made 15 errors and has been retrained 4 times on them on 4 separate dates
etc
I need to be able to drag the formula down and have it reference different people