rushthecourt
New Member
- Joined
- Jul 8, 2007
- Messages
- 35
Hi -
Using the following formula:
=SUM(IF(ROW(C4:C4997)>=LARGE(IF(C4:C4997="x",IF(K4:K4997<>"",ROW(C4:C4997))),4),IF(C4:C4997="x",IF(E4:E4997="A",IF(K4:K4997<>"",1)))))&"-"&SUM(IF(ROW(C4:C4997)>=LARGE(IF(C4:C4997="x",IF(K4:K4997<>"",ROW(C4:C4997))),4),IF(C4:C4997="n",IF(E4:E4997="B",IF(K4:K4997<>"",1)))))
I am trying to look the last 4 times col. C = x. If there are 4 or more times where col. C = x, then it gives me a notation that I want (such as 3-1, or 2-2).
The problem arises when there are <4 times where col. C = x. In those cases I'm getting the #NUM! error, rather than the notation 2-1 or 0-3, for example.
Can someone please help?! Thanks.
RTC
Using the following formula:
=SUM(IF(ROW(C4:C4997)>=LARGE(IF(C4:C4997="x",IF(K4:K4997<>"",ROW(C4:C4997))),4),IF(C4:C4997="x",IF(E4:E4997="A",IF(K4:K4997<>"",1)))))&"-"&SUM(IF(ROW(C4:C4997)>=LARGE(IF(C4:C4997="x",IF(K4:K4997<>"",ROW(C4:C4997))),4),IF(C4:C4997="n",IF(E4:E4997="B",IF(K4:K4997<>"",1)))))
I am trying to look the last 4 times col. C = x. If there are 4 or more times where col. C = x, then it gives me a notation that I want (such as 3-1, or 2-2).
The problem arises when there are <4 times where col. C = x. In those cases I'm getting the #NUM! error, rather than the notation 2-1 or 0-3, for example.
Can someone please help?! Thanks.
RTC