Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1

Logic Statement

I have set up a spreadsheet where a cell on the far right determines the
largest bid (number) in a range of cells the the left. [=LARGE(D7:U7,1)] I
also want to display the name of the bidder (always on the row above that
largest number. In this case row "E".

How can I do that?

Marc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help w/ logic statement in excel	bettinab	Excel Worksheet Functions	2	August 26th 06 02:00 AM
rather complex logic statement	[email protected]	Excel Worksheet Functions	6	March 31st 06 08:32 PM
Logic Statement	abierly	Excel Worksheet Functions	3	March 14th 06 06:13 PM
Using 'AND' logic in a SUMIF statement	IpcTrain	Excel Worksheet Functions	2	March 10th 06 05:39 PM
Two Logic tests in an IF Statement	timmadge	Excel Worksheet Functions	2	February 7th 06 03:15 PM

All times are GMT +1. The time now is 04:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us