#1
|
|||
|
|||
get value form columns
suppose we have values in A1=2,A2=5,A3=7,A4=6,A5=4 and in B1=f,B2=s,B3=z,B4=s,B5=t.how to get maximum value from column A(which is 7) and how to get value from column B which is in front of maximum value from column A(which is z) |
#2
|
||||
|
||||
IN C1, try: =MAX(A1:A5)
Then in D1, try: =INDEX(B1:B5,MATCH(C1,A1:A5,0)) |
#3
|
|||
|
|||
Dear Friend,
Kindly use below formula =INDEX($A$1:$B$5,MATCH(MAX($A$1:$A$5),$A$1:$A$5,0) ,2) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert 8 columns into 3 columns | BendixB | Excel Programming | 2 | 08-08-2018 12:39 PM |
Need to change table to text so that both columns merge to form 1 line | jrasicmark | Word | 3 | 02-24-2015 07:28 AM |
designing a custom outlook form - this form is for only sending mails nt collect data | balamuralibm | Outlook | 0 | 05-21-2014 08:08 AM |
Form Fields - Create blank form text field with if statement? | LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |