Find Maximum Value.

Closed
Neeraj Kumar Singh - Jul 23, 2009 at 08:14 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 23, 2009 at 10:56 PM
Hello,

I want to find the maximum value from text columns i.e.

Code
N10001
N10002
N10003
N10004
N10005
N10006
N10007
N10008

I have this type of data, and i want to know find the maximum value from this code??
i.e. I want to find the data of maximum value of "N10008"

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 23, 2009 at 10:56 PM
Hello Neeraj

Get the number part by using the formula =RIGHT(A1,4)*1
I hope the rest you can do
0