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!


--
arjcvg
------------------------------------------------------------------------
arjcvg's Profile: http://www.excelforum.com/member.php...o&userid=12713
View this thread: http://www.excelforum.com/showthread...hreadid=273472

One way ..

Assume this sample data set is in Sheet1, A1:D4

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
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"arjcvg" wrote in message
...

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!


--
arjcvg
------------------------------------------------------------------------
arjcvg's Profile:
http://www.excelforum.com/member.php...o&userid=12713
View this thread: http://www.excelforum.com/showthread...hreadid=273472

=MAX(B2:H2)

--
Mike

"arjcvg" wrote in message ...