Combine "sort within groups" and "identify duplicate/unique values" in two different variables.
Is it possible in Excel to identify unique values in column "person" and sort it within group in column "days". I can do this I SPSS, but cant get it right in Excel.
Example
"Person" contains both unique but mostly duplicates (the same person occurs more than once). "Days" contains a numeric value (extracted from number of days between two dates). Now I want to extract the lowest number of Days for every unique person, e.g. A = 12, B = 34 and so forth.
Person Days
A 12
A 23
A 37
B 56
B 34
C 12
C 10
Excel makes it hard to filter out unique values in more than one column at the time.
Excelfunctions delete duplicate doesn’t seem to solve the problem, neither do rank cases with color-theme (don’t know the word in English).
Any help appreciated
|