I have a list of parts
M01
M02
M03
P04
etc
i want to formulatically? find the highest value of any of these. I've tried =max(right(1:1,2))
but that doesnt work.
I'm sure this is an easy one but im stuck! Please help! thanks!
I have a list of parts
M01
M02
M03
P04
etc
i want to formulatically? find the highest value of any of these. I've tried =max(right(1:1,2))
but that doesnt work.
I'm sure this is an easy one but im stuck! Please help! thanks!
Last edited by hansonrl; 02-12-2010 at 01:45 PM. Reason: forgot a ( in formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks