Re: $$Excel-Macros$$ Re: how to search for max value in alpha neumeric range or col.

Hi Amit, Thanks for helping. I am confused with your 3rd. step. Can you please explain? Thanks On Wednesday, April 10, 2013 11:23:39 PM UTC-7, Amit Desai (MERU) wrote: > > Assuming you have each ID of 6 characters, What you can do is; > > 1) In B2, =Left(A2,3) – this will separate your fi

$$Excel-Macros$$ how to search for max value in alpha neumeric range or col.

I have a sheet with lot IDs in Col A AAA100 CPP100 AAA101 AAA102 CPP101 and so on. I need to find max value on AAA series or in CPP series, I can change that to suite my needs. if there can be a vb code it would be nice. Thank you -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo