ExcelBanter - Non unique records only

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Non unique records only (https://www.excelbanter.com/excel-programming/383591-non-unique-records-only.html)

mit05

Non unique records only

Hi,

I would like to get from a range the non unique records. Something like
advanced filter do for unique record only.

How can I do that?

Thanks

Jim Jackson

Non unique records only

Are you thinking of records that fit within certain specs?

Selection.AutoFilter Field:=1, Criteria1:=" A", Criteria2:="< G"

--
Best wishes,

Jim

"mit05" wrote:

Hi,

I would like to get from a range the non unique records. Something like
advanced filter do for unique record only.

How can I do that?

Thanks

All times are GMT +1. The time now is 03:52 PM.