Re: Counting criteria

From: Herbert Seidenberg <herbds7-msxls@xxxxxxxxx>
Date: Tue, 17 Jun 2008 12:08:15 -0700 (PDT)

Or this array formula:

=LOOKUP(999,IF(FREQUENCY(IF((bin2-bin3>=0)*(bin1="FD"),ROW(bin1)),
IF(bin2<bin3,ROW(bin1)))>0,
FREQUENCY(IF((bin2-bin3>=0)*(bin1="FD"),ROW(bin1)),
IF(bin2<bin3,ROW(bin1)))))

Variation on a theme by Biff.
.

Follow-Ups:
- Re: Counting criteria
  - From: Max

References:
- Re: Counting criteria
  - From: andrew

Prev by Date: Calculating Intrest and Late Fees
Next by Date: Slow move from cell to cell
Previous by thread: Re: Counting criteria
Next by thread: Re: Counting criteria
Index(es):
- Date
- Thread