I have to be the one who knows where each piece of data is

That might be where you're getting twisted. You *don't* have to know where
the data is. Just look at my example. If it had involved 1000's of rows of
data I wouldn't know where the max value was so I told Excel to find it for
me using the MATCH function.

Once the "light goes on" you'll realize just how easy it really is.

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Hi TV and BL,
I'm still mumbling quietly. Can't quite get my head around an index being
a
storage place where I have to be the one who knows where each piece of
data
is.
Anyhoo chaps, thanks for the replies. I'll get there.
Regards - Dave.