Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel and Unique sorting

26 Sep 2011   #1
meebers

Windows 7 Professional X64 Service Pack 1
 
 
Excel and Unique sorting

Excel 2010. Trying to do an "unique" sort (as in data/sort/advanced/unique) for a simple data set of 3 columns and 4 rows. i.e. Sort the data on the first column but leave only the first instance of the name.

An example perhaps: 3 columns 4 rows

Before:
Jones | Bob | Fl
Smith | Joe | MA
Jones | Bob | Tx
Smith | Bill | MN

AFter:
Jones | Bob | FL
Smith | Joe | MA

Appreciate any suggestions.


My System SpecsSystem Spec
.
26 Sep 2011   #2
meebers

Windows 7 Professional X64 Service Pack 1
 
 

After a week trying to solve this problem it was pretty simple. I have to import about 1000 rows of data per week, and have been sorting then hiding the duplicates, a real pain. But there in front of me was the command "remove duplicates" It does what I wanted, remove duplicate rows and gives you the option of what column to select for the removal to be performed.
My System SpecsSystem Spec
26 Sep 2011   #3
Anak

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

Hi meebers, +rep for posting back the solution and marking thread solved!

Jeez, you even have your System Specs filled out!!!
My System SpecsSystem Spec
.

27 Sep 2011   #4
meebers

Windows 7 Professional X64 Service Pack 1
 
 

Quote   Quote: Originally Posted by Anak View Post
Hi meebers, +rep for posting back the solution and marking thread solved!

Jeez, you even have your System Specs filled out!!!
Thanks for the thumbs up, so just had to read your System Specs. I am impressed with your internet speed "DSL 100.0Mbps ". Do you have a direct connect with Penn State?
My System SpecsSystem Spec
27 Sep 2011   #5
Anak

Microsoft Community Contributor Award Recipient

Win 7 Home Premium 64bit Ver 6.1.7600 Build 7601 - SP1
 
 

I used to when my two younger brothers went there, but not anymore.
My System SpecsSystem Spec
Reply

 Excel and Unique sorting




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Is Product ID unique as well?
Yes, the product key is unique, but how is the ID created? Is that a pre-determined id for that particular version of Win7 or is if unique to the key?
General Discussion
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Unique 360/W7 issue?
I had my 360 routed through my laptop (Vista) for Live, and it worked flawlessly, How can I do this to my Desktop (W7)? My boss said something about opening ports, Adjusting my TCP/IP, and some other stuff like that. I'm a gearhead, I like cars, what he explained to me might as well be in greek. ...
Gaming
Excel 2010 sorting
Hi is it possible to lock columns and rows together so when i sort a spreadsheet i make sure all the rows and columns are sorted together and i dont leave out somthing Regards
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:26.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App