Thread
: [Solved]
Lookup a value from non-sorted data
View Single Post
04-25-2011, 04:34 AM
macropod
Windows 7 32bit
Office 2000
Administrator
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
Hi udea,
Yes, the formula uses the offset function to derive a dynamic range, the end of which is the maximum value.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
macropod
View Public Profile
Find all posts by macropod