I having some problems applying the formula you suggest, it seems to get
hung
on the ROW portion. Here is what my formula looks like (I am compounding
it
by trying to enter the formula on one sheet and pull data from the "Log"
tab
and the month to be checked for from the Sheet1 tab.
=count(1/FREQUENCY(IF((Log!$A$6:$A$500=I4)*(Month(Log!$E6:$E500)=Sheet1!$F$2,MATCH(Log!$B$6:$B$500&"",Log!$B$6:$B$500&"",0,(ROW
6:500)))
(Log1!ROW 6:500) is not accepted either.
Any guidance is very much appreciated.
RagDyeR said:
Try this *array* formula for 2 variables:
=COUNT(1/FREQUENCY(IF((A1:A10=6)*(MONTH(C1:C10)=9),MATCH(B1:B10&"",B1:B10&"",0)),ROW(1:10)))
--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of
the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
I was trying to edit my post because I sent it too soon. But thank you
for
the reply - I have implemented it and it worked the way I needed, May I
follow up on this?
[1] While it worked it had a few things I need to understand "Why it
Worked"
*Why the "N"?
*Why &""?
[2] How would I add another criteria such as in the month of Column C?
*(MONTH(Log!$C$1:$C$10)=9)*1?
(A) (B) (C)
5 001 9/29/08
5 002 9/28/08
5 002 8/15/08
5 003 8/19/08
6 004 9/27/08
6 005 9/27/08
6 005 9/27/08
7 9/27/08
7 006 9/28/08
8 007 8/15/08
Thanks so much for the help!