how to display data of input that is within a data range???

  • Thread starter Thread starter angelrain
  • Start date Start date
A

angelrain

:confused: how do i display a list of data that is within a dat
range?? i have a cell where user is able to enter an amount...say $100
this will enable the data which is the names of hotels, its rates wit
the input by user and the location of the hotels to be displayed...ho
do i go about doing it???

PS: attached is a screen shot of the excel worksheet...

+-------------------------------------------------------------------
|Filename: hotel rates.zip
|Download: http://www.excelforum.com/attachment.php?postid=2747
+-------------------------------------------------------------------
 
People in the Newsgroup, where most of the questions are answered (and this
is not Excel Forum) can not see your attachment. But guessing what you
might have,
Look at Data=>Filter=>Autofilter
 
Back
Top