Excel 97

  • Thread starter Thread starter wepeners
  • Start date Start date
W

wepeners

Please can anyone help???

I have two columns in Excel 97. The first contains a list of statu
values eg. pending, or granted or withdrawn. The second contains date
eg.01/12/1997, 05/06/2003. I woudl like to know how to get all th
granted apps before 31/12/2003. Can anyone help please
 
theres many ways, but an easiest way would be to do a
sort. Highlight the 2 columns, click on data, then sort,
then sort by status, then by date. this should group them
all together. hope this helps...toe
 
Hi

Mark the header cells at the top of your columns.
Data=>Filter=>Autofilter
Select the drop down on the Dates column and choose Custom
Select from the left had drop down, Less than or equal and in the white pane
opposite enter 31/12/2003

This will give a filtered list of the results you want
 
I woudl like to know how to get all the
granted apps before 31/12/2003.
Click to expand...

What do you mean -- "get all the granted apps"? Do you want a count of
them? Do you want to hide the rows that don't match?
 
Back
Top