I need to be able to copy all rows on Sheet 1 in which today's date exists in Column C onto Sheet 2 and pack them at the top. The dates in Column C do not run in order as the "due dates" vary depending on the project, and this is where I run into a problem. The functions I've used in the past for this get buggy when the dates in the column are out of order.
For example, this works great when pulling a range of dates that are entered in order, but not so much if they are out of order:
Coupled with:
Any ideas? Basically I want whatever is due for today, and today only, to display on Sheet 2.
For example, this works great when pulling a range of dates that are entered in order, but not so much if they are out of order:
Rich (BB code):
{=(COUNT(Grease!E:E)+1)-COUNT(IF((INT(INDIRECT("Grease!E2:E"&MATCH(10^308,Grease!E:E)))>=INT(B1))*(INT(INDIRECT("Grease!E2:E"&MATCH(10^308,Grease!E:E)))<=INT(B2)),INDIRECT("Grease!L2:L"&MATCH(10^308,Grease!E:E))))}
Rich (BB code):
=IF(INDEX(Grease!A:A,$C$1+ROWS($A$4:A4))=0,"",INDEX(Grease!A:A,$C$1+ROWS($A$4:A4)))
Any ideas? Basically I want whatever is due for today, and today only, to display on Sheet 2.