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...
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
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.