Finding Max value in column and returning value from left adjacent cell
Time act1
2 1.1
3 1.2
4 1.2
5 1.3
6 1.4
7 1.4
8 1.5
9 1.6
10 1.9
11 20
12 40
13 60
14 40
15 20
16 3
17 3
I need a formula which can find max value in act1 column and can return the value in adjacent cell in Time column
For example max value is 60 in act1 column I want a formula which can give me value 13 which is in Time column.
Regards
Try this...
=INDEX($A$1:$A$16,MATCH(MAX($B$1:$B$16),$B$1:$B$16,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
Please try this, it will work.
Please Login or Register to view this content.
Thanks to All..it worked
Hello!
How do I apply this formula if I have over 100,000 rows of data and I need to get the max value (and its adjacent cell) of every 200th rows?
Thanks in advance!
Can anyone tell me how to modify the index formula allow finding values when filtering the information and not to factor in the hidden cells?
Hi, welcome to the forumOriginally Posted by rebduv1
Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks