Complicated Problem!

P

PH NEWS

Hi All,

In A1 I have a date (this date will always be changing), let's say 01/01/05.
In column B I will have a long list of dates. I would like excel to remove
all the dates in column B if they are less than A1. Is this possible?

Cheers

SPL
 
B

Bernard Liengme

A couple of suggestions
1) use conditional formatting to 'hide' old dates by formatting them with
font colour same as background
2) use a 'helper column' with =IF(B1<$A$1,1,0) in B1 and copied down the
column; convert to values (Copy followed by Paste Special); sort by helper
column and delete the 'tail'. All this could be recorded as a subroutine.
best wishes
 
Top