Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logic Statement
Let's assume the names are in row 1, D1:U1
Try this: =INDEX(D$1:U$1,MATCH(MAX(D7:U7),D7:U7,0)) -- Biff Microsoft Excel MVP "Marc" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logic Statement
Try:
=INDEX(D6:U6,MATCH(MAX(D7:U7),D7:U7)) This will return the first name if there is a tie for the highest bid. if you want to go on and get the 2nd highest etc hten use your Large() function inplace of the MAX() function. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Marc" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help w/ logic statement in excel | Excel Worksheet Functions | |||
rather complex logic statement | Excel Worksheet Functions | |||
Logic Statement | Excel Worksheet Functions | |||
Using 'AND' logic in a SUMIF statement | Excel Worksheet Functions | |||
Two Logic tests in an IF Statement | Excel Worksheet Functions |