Filtering of prescription rows (records?) for Excel 2000

G

GBL

Hi:
I have been keeping prescription rows (records?) data on Excel 2000 with
several fields of worksheet data, one of which is a depletion date (the "L"
column). I wish to filter-out all worksheet records (rows) except the
active ones based on this depletion date by comparing it to todays date.
Trouble is, I do not know how to do it. Can anyone help me?
 
B

Bernie Deitrick

GBL,

Sort your data table based on column L, then delete rows based on your date
criteria - they will be grouped together, either at the top or the bottom of
the data set.

HTH,
Bernie
MS Excel MVP
 
B

BarryB

Use the following formula
=IF(L2-TODAY()<0,"Old",IF(L2-TODAY()<5,"Current","Future")) in an
unused column. Then apply filters across your dataset and use th
dropdown to highlight what you want.
By changing the < numbers you can set different thresholds. If yo
only want to see ones that match today's date, then use L2 = today().
The danger with that approach is you could overlook items if you miss
day.
This appears that you are using this to track prescriptions fo
filling. If you have (or add) a column that denotes the prescriptio
is filled, you can nest the above formula in another to ge
=if(x2="Filled","",if(L2-TODAY()<0,"Old",IF(L2-TODAY()<5,"Current","Future")))
 
Top