|Posted: July 15, 2005, 7:42 am - IP Logged|
You might want to consider this formula...I use it to track how many times a number for a given day of the week has occurred. I am sure it can be adjusted as you need it to check to see when a number has occurred with another number. Of course, I am sure there are better ways to check as well.
Breakdown of the formula
SUMPRODUCT(--(Cash4History!$A$2:$A$141 <--Range holding the Day of week
=$AN$2) <--Day match to check for
,--(Cash4History!$D$2:$D$141 <--Range holding the numbers being searched
=$AM3)) <--Number Match to check for