Help please

[clares]

Has anyone any ideas how I could compare several figures and then display the name that represents the lowest value. I have thought about using if and or statement but feel that this would be a long winded approach. Any thoughts or code would be most appreciated.

Thanks in advance

[Aladin Akyurek]

On 2002-04-26 02:36, clares wrote:
Has anyone any ideas how I could compare several figures and then display the name that represents the lowest value. I have thought about using if and or statement but feel that this would be a long winded approach. Any thoughts or code would be most appreciated.

Thanks in advance

See my contrib at:

http://www.mrexcel.com/board/viewtop...c=3146&forum=2

That should apply to min values too.