I have (worksheet 1) that lists items but a "key code" and mutiple items can have the same "key code".
Is there an Excel funtion I can use in (worksheet 2) that will sear through (worksheet 1) and only show the unique values?
Thanks in advance!
Hi,
I wanted to count the Unique records in ColumnA of TableXYZ.
Using the Group by and count will give me all the records in ColumnA, but I just want the unique total records. Do you know how to do this.
... I know I can just use the "group by" and then see how long the table is but I wanted to get the result as an output.
Also do you know how to set a variable in a macro equal to the count of this query? I tried fiddling with the sql statement but I couldnt get it to work.
Thanks
Hello,
I have a column of numbers, where some are duplicated.
The 'filter unique records' feature gives us the first entry of a duplicate.
Is there any way to make Excel choose the last duplicate instead?
Thanks,
David
Hello,
I have downloaded data to an excel spreadsheet by day and need to calculate the unique records by day. Then all the daily totals should equal the monthly total if I ran the same date range for the month by removing the duplicates to get the unique records.
How can I do this?
nolanstern
I have a question on Excel, I'll try to explain.
I am a data analyst and I received data to analyse monthly. This data is overlapping, in other words I will receive October data and then receive November data and some of the data overlaps or duplicates the prior months data. Is there a way I can merge the two months of data and then extract only the most current data from the two months, eliminating duplicate entries? You guys are the best if you can figure this one out.
Thanks for your help, George
Hi,
Can someone help
code for unique records match with one column to another column.
Thanks
Hi there,
I have a list of sales orders with contact names and addresses in Excel
format which I want to extract for mail shots. However within this list, I
have several orders from the same contact. I obviously don't want to send a
mail shot to the same guy more than once. How do I filter or using Macros to
extract the unique records only.
Data sample.
customer contact address etc.....
123456 Bob ......
123456 Bob ......
654321 Pete ......
234567 Steve ......
234567 Steve ......
345678 Bob ......
Many thanks
Peter
VBA Code -
I need unique records from column C to Column A.
Also,if column C is blank then D, E & F cannot be blank.
Regards
Oracle10g
I have an old excel sheet with products and a new one that has the old products plus the new products. When I filter for the unique records it just removes the duplicates, but that is not what I want. How can I find the new items only that are not the same on both sheets. I want the records that are the same on both sheets deleted so that I can see what the new products are. Can anyone help me with this? Thanks.
Is there a way to automatically create a list of unique records from a range. I know how to do it manually (data ... filter ... advanced filter ... copy to another location ... unique records only).
However, I want a live "unique records list" in another location that updates itself, automatically. For this example I'm just looking at one column of data. I have not been able to figure out how to do this and would be grateful for help on this.
Thank you.
