how to display a range of cells if "x" appears next to it

S

steve m

I have a list of 700 apartments in unit number order all
with their lease expiration month next to it. At the
bottom of my worksheet, I want to be able to type "12" in
a cell and have all the units with leases expiring in
December be displayed. I also want their other information
to follow with the unit number (about ten columns).

I appreciate any help I can get, Thank You!
 
D

Dave Peterson

I think I'd use a helper column of cells:

=month(a2)
(to retrieve the expiration month)

then apply Data|filter|autofilter to that column (or the whole range).

Then you could just filter on that column and show only the months you want.
 
Top