I have a feeling I should know this.
Let's say I have a list of 10 numbers in random order.
7
10
3
5
1
9
4
2
8
6
I would like to know the position of the smallest number.
Is there a function where I can give it SMALL(range,1) and have it tell me
it's in the 5th position?
Have a look at the INDEX() function...
Meant to include to look at the MATCH() function as well.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion