Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-12-2017, 04:08 AM
civilcervant civilcervant is offline Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Windows 7 64bit Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Office 2013
Novice
Combine "sort within groups" and "identify duplicate/unique values" in two different variables.
 
Join Date: Jun 2017
Posts: 2
civilcervant is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 06-12-2017, 04:14 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Windows 7 64bit Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
have you tried using a filter?
__________________
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
Reply With Quote
  #3  
Old 06-12-2017, 07:01 AM
civilcervant civilcervant is offline Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Windows 7 64bit Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Office 2013
Novice
Combine "sort within groups" and "identify duplicate/unique values" in two different variables.
 
Join Date: Jun 2017
Posts: 2
civilcervant is on a distinguished road
Default

Yes, I´ve tried but failed.
Reply With Quote
  #4  
Old 06-12-2017, 07:27 AM
xor xor is offline Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Windows 10 Combine "sort within groups" and "identify duplicate/unique values" in two different variables. Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Maybe like the attached
Attached Files
File Type: xlsx IdentifyDuplicates.xlsx (16.3 KB, 10 views)
Reply With Quote
Reply

Tags
combine, sort, unique

Thread Tools
Display Modes


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
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft