date range prroblem
 

In col-A ,I have dates entered in ascending order.
in Col-B,I have some blank cells and some entries in them.
I am trying to do this:
if(isblank(Vlookup(currentmonth date
entry/entries,A2:B100,1,false),print"done","not done")
in otherwords:
find all current month date or dates in Col- A,match corresponding values in
Col-B,and if any corresponnding value in Col-b is is not blank print
somethingin Col-c.
If there are no current month date entry/entries print something else in
Col-c- last blank available cell.
Any function or formula ?

date range prroblem
 

One simple play which gets you there

Assuming real dates in A2 down
In C2:
=IF(TEXT(A2,"mmmyy")=TEXT(TODAY(),"mmmyy"),ROW()," ")
Leave C1 blank

In D2:
=IF(ROWS($1:1)COUNT(C:C),"",INDEX(B:B,SMALL(C:C,R OWS($1:1))))
Select C2:D2, copy down to cover the max expected extent of data in col B,
say down to D500? Minmize/hide col C. Col D will return what you seek, with
lines neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TUNGANA KURMA RAJU" wrote:
In col-A ,I have dates entered in ascending order.
in Col-B,I have some blank cells and some entries in them.
I am trying to do this:
if(isblank(Vlookup(currentmonth date
entry/entries,A2:B100,1,false),print"done","not done")
in otherwords:
find all current month date or dates in Col- A,match corresponding values in
Col-B,and if any corresponnding value in Col-b is is not blank print
somethingin Col-c.
If there are no current month date entry/entries print something else in
Col-c- last blank available cell.
Any function or formula ?