Yes you can make different lists of variable length, then apply my formula
changing $F1:$F4 for whatever the new list is.

Cheers,
--
AP

"shalombi" a écrit
dans le message de news:
...

Ok so in my case i have 4 different types in need to separate in, so if
i make lists in separate collumns like you said F1:f4 for one thing and
G1:G5 in another i can reference to them that way?

Well ill try what you said, thank you for the prompt reply anyway.

Max


--
shalombi
------------------------------------------------------------------------
shalombi's Profile:
http://www.excelforum.com/member.php...o&userid=34967
View this thread: http://www.excelforum.com/showthread...hreadid=547037