This content has been marked as final. Show 3 replies
I am trying to sum the difference between two date values for unique combinations of Name, Date1, and Date2
I have data of the format:
And I want to sum Date2 - Date1 for unique combinations. In this case, Chuck would get 2, the first line of Sam would get 2, and the next 3 lines of Sam are all identical so would count once and be 2 for a total of 6.
Currently all I can get is 2+2+2+2+2=10
Anybody know how to code this?