Combine "sort within groups" and "identify duplicate/unique values" in two different variables.

civilcervant · #1 06-12-2017, 04:08 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error: "Changes made were lost...reconnect with server", when switching "from" field	randhurrle	Outlook	2	02-25-2015 06:51 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
'Linking' entered information to other "cells" from an original "cell" in MS Word	Wade	Word	6	09-03-2012 05:22 PM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM