First 20 rows containing a value (2003/SP2)

Topic

New Reply

Is there a filter or query in Excel that can return the first 20 occurrences of each of a set of values? That is, 20 rows per value (maybe less if there are <20 occurrences of a given value). The values will always be in the same column, if that's any help.

Thanks in advance,
Erik

Reply | Quote

Replies

Such a problem appears to be more suitable for Microsoft Access than for Excel.
I don’t think there’s an easy or built-in way to do it in Excel, you’d probably need VBA code.

Reply | Quote

I was afraid you’d say that.

Thanks for the advice.

Reply | Quote