Returning value from column b in column c, in a cell ajacent to

[Solved/Closed]
Report
Posts
1
Registration date
Sunday February 17, 2013
Status
Member
Last seen
February 17, 2013
-
 lawrencen -
Hello,


BHID MN
Samp 47.86
Samp 50.24
Samp 41.63
Samp 49.34
Samp 48.19
Samp 53.11
Samp 50.98
Samp 49.07
Samp 48.05
Samp 52.96
Samp 41.27
Samp 51.36
Samp 33.1
Samp 28.12

if BHID and MN represent column A and B respectively how can i show max Mn (from colum B) in column C, in a cell adjacent to the actual max in column B.

hope my question makes sense. Please help

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
use combination of Max and IF statement
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Hi lawrencen

Assuming your data is in A1:B15 including headers. In C2:

=IF($B2=MAX($B$2:$B$15),$B2,"") & copy down.

Kevin


@ rizvisa1. You are not very helpful!
Thanks a million > Kevin@Radstock

I wish i had your reply much earlier then i wouldn't have had sleepless nights. . .but i now know a smarter way for future problems, all thanks to you.