Help please

clares · Apr 26th, 2002, 03:36 AM

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 · Apr 26th, 2002, 03:48 AM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 03:36 AM	#1
clares Board Regular Join Date: Mar 2002 Location: Portsmouth.UK Posts: 543	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