That actually makes it easier (still array entered):

=SMALL(IF(COUNTIF($D$17:$D$76,$A$17:$A$76),IF(SUMI F($A$17:$A$76,$A$17:$A$76,$B$17:$B$76)<SUMIF($D$1 7:$D$76,$A$17:$A$76,$E$17:$E$76),$A$17:$A$76)),COL UMNS($A:A))

Biff

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:6a2da75e7fa27@uwe...
Hi Biff,

Thank you very much. Great Formula!

Is it possible to have the Numeric Labels that are in columns "A" and "D"
returned in ascending order across the row?

Cheers,
Sam

T. Valko wrote:
Try this (array entered: CTRL,SHIFT,ENTER):

=INDEX($A$17:$A$76,SMALL(IF(COUNTIF($D$17:$D$76, $A$17:$A$76),IF(SUMIF($A$17:$A$76,$A$17:$A$76,$B$1 7:$B$76)<SUMIF($D$17:$D$76,$A$17:$A$76,$E$17:$E$7 6),ROW(A$17:A$76)-ROW(A$17)+1)),COLUMNS($A:A)))

Copy across until you get #NUM! errors. If you want an error trap, maybe
use
conditional formatting to hide them.

Biff

--
Message posted via http://www.officekb.com