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.