*I* didn't sort descending; it just seems to me that it's the obvious
way the OP would have VALUE1 in 1200 to 3500 like he said. As far as
spell binding [sic] contributions go, *you're* the one who contributed
the gratuitous (and puzzling) notion that you couldn't see how the OP
could have the situation he said he has.

Alan Beban

Tom Ogilvy wrote:
Why would you sort descending? I am sure you can fantasize any number of
colorful scenarios. Your spell binding contributions continue to scintillate
the assembled masses. <g

--
Regards,
Tom Ogilvy

Alan Beban wrote in message
...

Huh??? With 1199 VALUE2's and 2301 VALUE1's in D1:D3500, sorted in
descending order. Did I miss something in your question?

Alan Beban

Tom Ogilvy wrote:

If you only have two values and they are grouped together/sorted, how

could

the area be 1200 to 3500

in any event, if that is the case, the you could use Find to find the

first

Value1 as well.