Hi Ron,
Thank you very much for persevering.
Ron Coderre wrote:
OK....Here's the latest in a series of final formulas : \
A11:
=LARGE(INDEX((FREQUENCY((($A$2:$H$7<0)*($A$2:$H$ 7=$A$3:$H$8)*($A$2:$H$7+COLUMN($A$2:$H$7)*1000)),( $A$2:$H$7+COLUMN($A$2:$H$7)*1000)+($A$2:$H$7<$A$3 :$H$8)*9999)=1)*ROW($A$1:INDEX($A:$A,ROWS($A$2:$H $7)*COLUMNS($A$2:$H$7)+1)),0),COLUMNS($A$11:A11))
Copied across yields these results:
420 170 280 101 430 107
This is Great!
In ascending order that would be:
101 107 170 280 420 430
Yes,
Dare I ask?
Can the Formula actually list them in ascending order?
***********
Regards,
Ron
XL2002, WinXP
Cheers,
Sam
--
Message posted via
http://www.officekb.com