Selecting particular rows containing interesting data

[Agent Wild]

Hi,

I have a sheet whereby every couple of thousand rows there's a row o
significant interest (there's a value in a column). How can
automatically select these rows or hide the other rows so that I ca
show only the 'interesting' rows?

Thanks in advanc

 

[Roger Govier]

Hi

Data>Filter>Autofilter>use the dropdown on the column containing the
"data of interest" and select the value you want to see.

--
Regards

Roger Govier


"Agent Wild" <[email protected]>
wrote in message
news:[email protected]...