Filter on row numbers not cell contents

[daza34]

Hi,

Is there any way to filter on a large amount of row numbers not the contents on the cells?

Thanks

 

[Fluff]

Depends on what you want to do, but one possibility would be to put a formula in a blank column & then filter on that.

 

[william_man]

If you have a list of row numbers stored in column A of Sheet1 you can use this formula to filter by row numbers contained in that list:

=MATCH(ROW(),Sheet1!A:A,0)

This will return a number if the row number for that cell exists in the list, and #N/A if it doesn't.