![]() |
|
![]() |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
Hi and welcome
have you tried using a filter?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
Yes, I´ve tried but failed.
|
#4
|
|||
|
|||
![]()
Maybe like the attached
|
![]() |
Tags |
combine, sort, unique |
|
![]() |
||||
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 |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |