Advanced Filtering

Topic

New Reply

I am trying to do an advanced filter. However, it seems as though the first item in the column of 25 I am trying to do a unique filter on keeps getting repeated. For example, if the first item in row 1, column 1 is “John”, and “John appears also at row 12, column 1, John is included 2 times in the unique filter. Any ideas?
Thanks in advance

Reply | Quote

Replies

Make sure one of them doesn’t have a space preceeding or following it, that would make it unique.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

I did that. I even re-typed the duplicating entries in the original column so that both would be the same, and it still is repeated!

Reply | Quote

Could you possibly post a sanitized version of your workbook?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Here you go…this is the actual spreadsheet; I referenced 25 in my column in my original post just for example purposes.

Reply | Quote

Seems to work for me here’s the workbook.
Note the Defined Names of Database, Criteria, Extract! If you use these names to define your ranges the Advanced Filter dialog will pick up the ranges automatically.

Note: I did this test in 2003 converting the file in both directions.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

I was just simply doing an advanced filter-unique characters only and copying the results to a same-sized column elsewhere on the spreadsheet; I wasn’t using the criteria-how does that work?

Reply | Quote

Attached are 3 pages from a course I created on Excel databases years ago so the screen shots are dated but the concepts are all still the same. I hope this helps.

Also note the sheet I posted has the Criteria range blank which equals all records, see the note with the bomb icon in the attached pages.

BTW: When using the Advanced Filter it helps if you have labels at the top of your columns, you’ll notice I added it to the sheet you posted.

Post back if you need more help.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thanks. I’ll take a look.

Reply | Quote

More than ‘helps’ – advanced filter assumes the top row is a header row, hence your problem. 

Reply | Quote