Removing entries using Selection.Autofilter, but keeping the greatest 100 entries?

Hi all,

I've been trawling the archives and I'm at my wits end, so I thought I would post my question. Any and all help would be appreciated!

My problem is thus:

I have a large table with > 100,000 points, and many, many instances of these tables, but thankfully each datapoint is clearly classified with unique labels. Here's a small, truncated example of what my table looks like:

#	Type	Value
1	A	7
2	A	10
3	B	2
4	C	8
4	C	5

Imagine that there are lots more values, but you get the idea - clearly labeled entries that each have a value associated with them. I want to be able to remove all instances of A and C, BUT, of those instances of A and C, I want to keep the greatest 100 values.

So far I have something like below, where I can get rid of all instances of A/C, but I can't figure out how where to add the code to keep only the greatest 100 values of A/C.

Please Login or Register  to view this content.

Thanks so much for any help you might be able to give!

Hi artenry,

Nice code, easy to understand.

You may want to try the following:
a. Sort field 2 in descending order with AutoFilter
b. Start the deletion as row 102.

Lewis