Forum Discussion
Formula Help - Unique Value Count and Sum
Hi there, I have some questions on how to write a formula, and also a query about how unique formulas work? Is the "unique" one just the one that appears first in a list? And if I re-sorted the list,...
Ashleigh,
could you provide a sample workbook with the desired results?
Hi there, I guess it would really depend on how excel decides which entry is the unique one.
At the moment, I am guessing it just takes the first instance of a result in list order. I'm really not sure if what I'm asking for can be done.
Below is two examples of the outcome I am looking for:
Both are just re-ordered slightly. Looking for the first unique value in column B and summing column E based on column C's status.
Insert a pivot table: "Status" in row area and "Duration" in values area.