If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#12
|
|||
|
|||
How can I paste a unique values list?
On the same Note (Unique Values).....
I have two columns (A1:A88) and (B1:B90)....the columns have some similar data but I would like to filter out the data that is not unique to either of the columns. In other words...my results should only give me data that is not similar in both records. A majority of the data is similar but I want to filter out data that does not match on both columns.....ANYONE??? "Dorothy" wrote: On 24 май, 09:57, unique records unique wrote: "jak roodi" wrote: I have a very big list contains a lot of repeated values and I want to get a copy of the same list BUT only with unique values. For Example the column Reg.No. includes the following Numbers: 1154 1168 1166 1154 908455 907558 1166 908455 1154 1166 List might have thousans of records. I want to get a copy of this list without repeating any of the numbers included. { Uniqe value list }. Thanks and regards. JAK Hi, JAK You can use an Advanced Filter to extract a list of unique items in your worksheet Select a cell in the list From the Data menu, choose Filter, Advanced Filter. Choose 'Copy to another location'. For the List range, select the column(s) from which you want to extract the unique values. Leave the Criteria Range blank. Select a starting cell for the Copy to location. Add a check mark to the Unique records only box. Click OK. That's it! If you want to find unique values between two Excel files then you should use filord utility from www.filord.com |
#13
|
|||
|
|||
How can I paste a unique values list?
Kagzz-
What is the relationship between the columns? Sight unseen, one thought would be to use column C to concatenate AB, then dedup that. That idea presupposes a couple things, though: that neither A nor B values are completely unique, and that the 'hit' ratio between the two would produce a useful result. Example: Alpha Beta AlphaBeta Gamma Delta GammaDelta Alpha Delta AlphaDelta Gamma Beta GammaBeta In the third column, you now have a single value representing the pair which you can manipulate/deduplicate/autofilter for unique. "Kagzz" wrote: On the same Note (Unique Values)..... I have two columns (A1:A88) and (B1:B90)....the columns have some similar data but I would like to filter out the data that is not unique to either of the columns. In other words...my results should only give me data that is not similar in both records. A majority of the data is similar but I want to filter out data that does not match on both columns.....ANYONE??? |
#14
|
|||
|
|||
How can I paste a unique values list?
Hi,
I am following the steps below which are programmed as part of a simple macro, but the unique value in the first line of the filtered results is being repeated as the in the last line of the filtered results. I have checked spacing of the data, re created the macro multiple times and cleaned up the source data. I can't figure out why that one value is being repeated. Any advice is appreciated. Thanks Tom "Joham Shason via OfficeKB.com" wrote: Hi, You can do it by using the filter options in data menu. Just check this steps out. Go to data -- FILTER -- advanced filter -- Select copy to another location -- select the list range - select the new location where data should be copied -- Check Unique records and click on OK. That should work. C Ya. -- Message posted via http://www.officekb.com |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
URGENT HELP: Pick out unique values from repeated values in one ce | Sonal | Worksheet Functions | 4 | September 13th, 2004 06:30 PM |
Formula to return non-zero values in a list | Naoki | General Discussion | 4 | August 17th, 2004 01:51 PM |
How do you Count the number of unique values in a list ? | owenchan | Worksheet Functions | 1 | June 3rd, 2004 04:43 PM |
LIST unique values | James Gilbert | Worksheet Functions | 3 | May 31st, 2004 11:16 AM |
Unique entries in a filtered list | Worksheet Functions | 1 | November 21st, 2003 01:08 PM |