How do I filter data between two dates.
Dates are in cells A1 and B1
The data run from cells A4:C100.
column A= date
column B=Unit
column C= Data (% figure)

Having selected a period between two dates and a unit. The result is shown
on cell
A102.

--
AOU

I assume you mean advanced filter, out the date header in let's say H1 and
I1
in H2 put ="="&A1 and in I2 put ="<="&B1

then as criteria range select H1:I2


--


Regards,


Peo Sjoblom



"AOU" wrote in message
...
How do I filter data between two dates.
Dates are in cells A1 and B1
The data run from cells A4:C100.
column A= date
column B=Unit
column C= Data (% figure)

Having selected a period between two dates and a unit. The result is shown
on cell
A102.

--
AOU