was wondering if there is a more elegant way:
IF(A2=E2,A1,IF(B2=E2,B1,IF(C2=E2,C1)))
Like I said, not pretty and limited to testing on 7 columns.
-----Original Message-----
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 4:56 PM
To: CF-Community
Subject: Re: Excel Brainteaser
DO you mean COLUMN A and COLUMN B?? the last time I used excel, the
alphabets represented columns.
Please verify this so i can help :-D
----- Original Message -----
From: Marwan Saidi
To: CF-Community
Sent: Tuesday, June 01, 2004 3:39 PM
Subject: Excel Brainteaser
Ok, can anyone tell me if this can be done:
Say I have a spreadsheet as follows:
Fred Don Ginger
1500 1000 500
(for the text representation, row A has names: Fred, Don, Ginger; row B
has
values: 1500, 1000, 500)
Say I want to know the smallest value in row B. I use the SMALL() function
in Excel to put this in column E. The question is, is there a way to
determine the name that goes with that small amount and put it in row A,
column E?
Does this make sense to anyone? Is it doable? One fresh apple-cinnamon
muffin to whomever can answer this one...
Marwan Saidi
Webmaster - PFH
[EMAIL PROTECTED]
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
