results table dilemma -part 2
 

hi again,

in addition to my previous post, what formula can you suggest for me to be
able to find matching dates and the dates of the week before.

thanks,
--
"excel newbie"

results table dilemma -part 2
 

"melmac" wrote:
.. what formula can you suggest for me to be
able to find matching dates and the dates of the week before.

As explained in the response to your earlier post,
the criteria could be something like this:
In your results sheet,
Assume a specific date will be input in A2
In B2:
=IF($A$2="","",IF(AND(A!B2=$A$2-7,A!B2<=$A$2),ROW(),""))
Leave B1 empty. Col B is the criteria col.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---