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

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

HI Lalit, Thanks for helping me. Yes there is always 2 or 3 alphabets in the beginning, followed by numbers and sometimes with decimals. I hope I explained it well. On Wed, Apr 10, 2013 at 8:40 PM, Lalit Mohan Pandey < mohan.pande...@gmail.com> wrote: > Is there any pattern of ID's like starti

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

Assuming you have each ID of 6 characters, What you can do is; 1) In B2, =Left(A2,3) - this will separate your first 3 characters which are alphabetic. Drag the formula down 2) In C2, =right(A2,3) - this will separate your last 3 characters which are numeric. Drag the formula down. 3