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