Selecting rows based on cell entries

M

m.cain

Hello,

I want to select specific rows from a sequential list based on a cell
value.

Example:

Name: Age:
Mark 12
Luke 15
Jon 14
Matthew 12
Fred 12

I want a method of selecting only rows where Age is 12. Note that I
don't want to have to manually select each row, or even sort them by
age and then select each row manually. I want an automatic method that
I could use in a macro eventually.

Thanks for your help!
 
M

Max

Assuming "Age" is in col B, data from row2 down,
just do a Data > Filter > Autofilter on col B
then you can select the age from the autofilter droplist in B1
 
S

Stefi

Data/Autofilter does it! Record a sample filtering as a macro then you can
edit it to adjust to your needs!

Regards,
Stefi


„m.cain†ezt írta:
 
Top