Advanced filter

M

M.A.Tyler

Is it possible for the results of a filter to only show the first 10 or 11
rows of data?
I'm filtering some sheets of data, copying to another page, based on two
criteias. The results may produce 100+ rows of data. Can I further the
process to only show the top 10 or 11 rows? Hopefully within the same filter,
to avoid creating another sheet. Anything beyond the first 10 or 11 rows are
too dated for my use.
 
M

M.A.Tyler

Currently filtering sheet 8, to sheet 9, criteria is in sheet 1; F17:F18. Not
sure thats the answer that your looking for so, I'll go a step further..
Column header is a state name: Michigan, F18 contains sales reps last name:
Smith, Jones.....
 
P

Peo Sjoblom

Leave F17 blank (empty), in F18 put

=AND(A21=$E$18,COUNTIF($A$21:A21,$E$18)<=10)


where A21 is the first data cell in the Michigan column, replace with the
first data cell (not the header, the first last name in Michigan) in your
Michigan column and where E18 is the cell where you put the name you want to
filter for, you can leave out E18 but then you have to edit the formula
itself when you change
then name from Smith to Jones etc.. Use both F17 and F18 in your criteria
range even though F17 is blank. It will give you the name and the first 10
occurrences of that name, if the name occurs less than 10 time it will show
as many as there are. It's important that you follow the absolute/relative
cell references in my example


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top