Hi Domenic,

I'll try to clarify.

Your original Formula provided the correct answer based on SEARCH/ sort type
Ascending For Numeric Label and Ascending for Numeric Value. However, I
require the Formula to use SEARCH/ sort type Ascending for Numeric Label and
Descending for Numeric Value. That is the only change or difference to the
original Formula you provided.

Cheers,
Sam

Domenic wrote:
Sam,

I'm having a difficult time trying to understand the process involved.
Can you please provide a few examples under the differing situations,
along with the step-by-step thought process involved?

Hi Domenic,

[quoted text clipped - 103 lines]
Cheers,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200601/1