Definitely look at Domenic's response.
Where I misinterpreted your criteria, built a formula that listed
same-column multiples, then fiddled with it to list consecutive dupes....he
paid attention. His formula does what you want without all the side trips.

***********
Regards,
Ron

XL2002, WinXP


"Sam via OfficeKB.com" wrote:

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