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

Solved/Closed
lawrencen Posts 1 Registration date Sunday February 17, 2013 Status Member Last seen February 17, 2013 - Feb 17, 2013 at 09:19 AM
 lawrencen - Feb 19, 2013 at 12:27 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 17, 2013 at 11:15 AM
use combination of Max and IF statement
0
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Feb 18, 2013 at 01:44 AM
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!
0
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.
0