Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for max number and the data adjacent to the cell
Hello,
I need a formula to look for a range of cells and display the max number among them along with the data adjacent to the cell in a different cell. Let me explain in this way.. A1 B1 ABC 231 KJH 122 UJJ 422 IOJ 321 FJK 545 I need a formula which looks the maximum number from B1 to B5 and get displayed in B10 (=MAX(B1:B5) can be used) but I want the data adjacent to the max number (FJK in this case) to get displayed along with the max number in the cell A10. How can I do that? Thanks in advance Sasikiran |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for max number and the data adjacent to the cell
=INDEX(A:A,MATCH(MAX(B1:B5),B:B,0))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sasikiran" wrote in message ... Hello, I need a formula to look for a range of cells and display the max number among them along with the data adjacent to the cell in a different cell. Let me explain in this way.. A1 B1 ABC 231 KJH 122 UJJ 422 IOJ 321 FJK 545 I need a formula which looks the maximum number from B1 to B5 and get displayed in B10 (=MAX(B1:B5) can be used) but I want the data adjacent to the max number (FJK in this case) to get displayed along with the max number in the cell A10. How can I do that? Thanks in advance Sasikiran |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for max number and the data adjacent to the cell
B10: =MAX($B$2:$B$6)
A10: =INDEX($A$2:$A$6,MATCH($B$10,$B$2:$B$6,0)) Regards, Stefi €˛Sasikiran€¯ ezt Ć*rta: Hello, I need a formula to look for a range of cells and display the max number among them along with the data adjacent to the cell in a different cell. Let me explain in this way.. A1 B1 ABC 231 KJH 122 UJJ 422 IOJ 321 FJK 545 I need a formula which looks the maximum number from B1 to B5 and get displayed in B10 (=MAX(B1:B5) can be used) but I want the data adjacent to the max number (FJK in this case) to get displayed along with the max number in the cell A10. How can I do that? Thanks in advance Sasikiran |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for max number and the data adjacent to the cell
Thanks a lot Bob... Its working fine..
"Bob Phillips" wrote: =INDEX(A:A,MATCH(MAX(B1:B5),B:B,0)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sasikiran" wrote in message ... Hello, I need a formula to look for a range of cells and display the max number among them along with the data adjacent to the cell in a different cell. Let me explain in this way.. A1 B1 ABC 231 KJH 122 UJJ 422 IOJ 321 FJK 545 I need a formula which looks the maximum number from B1 to B5 and get displayed in B10 (=MAX(B1:B5) can be used) but I want the data adjacent to the max number (FJK in this case) to get displayed along with the max number in the cell A10. How can I do that? Thanks in advance Sasikiran |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
Counting a specific number only if an adjacent cell has something | Excel Discussion (Misc queries) | |||
find data in adjacent cell | Excel Discussion (Misc queries) | |||
copying data to an adjacent cell | Excel Discussion (Misc queries) |