Finding and Showing the Largest

[arjcvg]

Hi! For example I have the following data:

Name Samp1 Samp2 Samp3 Samp4 Samp5 Samp6 Samp7
John 6 30 28 5 1
12 2


How would I get the biggest? In this case Return 30

Thanks

 

[Max]

One way ..

Assume this sample data set is in Sheet1, A14

Name Samp1 Samp2 Samp3
John 6 30 28
Steve 47 7 31
Peter 6 37 36
etc

(Names are assumed unique in col A)

In Sheet2
-------------
Names are listed in col A, A2 down

Name
John
Steve
Peter

Put in B2:

=MAX(IF(Sheet1!$A$2:$A$100=TRIM(A2),Sheet1!$B$2:$D$100))

Array-enter the formula in B2 with CTRL+SHIFT+ENTER
instead of just pressing ENTER

Copy B2 down

Col B will return the results (for the sample data):

Name
John 30
Steve 47
Peter 37

Adapt / extend to suit

 

[MikeY]

=MAX(B2:H2)