date range prroblem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TUNGANA KURMA RAJU - 24 May 2008 20:56 GMT

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 ?

Reply to this Message

Max - 24 May 2008 21:09 GMT

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,ROWS($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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> In col-A ,I have dates entered in ascending order.
> in Col-B,I have some blank cells and some entries in them.
[quoted text clipped - 8 lines]
> Col-c- last blank available cell.
> Any function or formula ?

Reply to this Message