I have 10 total columns in excel with lot of data. However, I want to find the unique records for 3 of the columns. For example unique records for the columns 'BPA', 'Govt Contract', and 'Task Order'. How would I do this? Thank you.
I have 10 total columns in excel with lot of data. However, I want to find the unique records for 3 of the columns. For example unique records for the columns 'BPA', 'Govt Contract', and 'Task Order'. How would I do this? Thank you.
Corinthian,ionic,doric
what does this mean?
Hello baller99,
Please attach a sample file for more details , i cant's understand what you want
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
it wont let me upload the file. So there are 3 columns of data in excel. I want to get all the unique rows from the 3 columns. There are duplicates in each column so I need to get the unique records from the 3 columns.
i think
you can use costume auto filter simple
AdvancedFilter -> unique items
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Over the centuries three different styles (also called Orders) of column were used by the Greeks: Doric, Ionic, and Corinthian. since your post title isi tried to guess what it meant. perhaps if you were a bid More specific in the title you wouldn't get fatuous answersthree columns
Last edited by martindwilson; 12-19-2008 at 09:53 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks