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

[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!

 

[mzehr]

Hi,
Check out:
http://www.contextures.com/excelfiles.html#Filter

 

[Frank Kabel]

Hi
a different approach: Use 'Data - Filter' for this

 

[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.