Is it possible to do advanced filter for unique records. The data should be filtered uniquely based on 3 fields. In the below attached excel sheet, there are 4 columns (Invoice#, Location#, Type and Period). I want to find unique invoice numbers for each location, type and period.
Advanced Filter
-
-
-
Re: Advanced Filter
There is a checkbox in the Advanced Filter Wizard for Unique Items
-
Re: Advanced Filter
Hi Roy,
The Unique items cheque box in advanced filter option is only to filter the data on one field. But in this case I wanted to filter the data based on the other three fields
-
Re: Advanced Filter
Hi Kris
Sorry didn't read your post properly. I think you would need to use VBA to do this.
-
Re: Advanced Filter
Hi Roy,
Could you please help me to do this in VBA
-
-
Re: Advanced Filter
Hi Kris,
If you are trying to get the unique invoices then you try this:
1. Move the data to new book(as this is going to be workings)
2. Use Subtotals to count the data based on invoice number wise
3. This will display invoice wise count of ...whatever
4. Select visible cells(Ctrl+F5 > special - select visible cells)
5. Copy and paste to a new sheet..Though a rude of doing, see if this helps. My settings here will not allow me to view your excel attachement(hope I understood your problem correctly).
HTH.
-
Re: Advanced Filter
It will be of great help, if somebody can help me to do this in VBA
Thanks a lot for your help Pradeep.
-
Re: Advanced Filter
Hi Murali:
Try the following. I hope this what you are after.
Code
Display MoreSub UniqueItems() Dim rngData As Range Dim wsData As Worksheet Set wsData = Sheet1 Set rngData = Range(wsData.Range("A1"), wsData.Range("A1").End(xlToRight).End(xlDown)) With rngData .AdvancedFilter xlFilterCopy, , wsData.Range("M4"), True End With End Sub
Regards
Maqbool
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!