Dear Friends,
Please help me in finding the maximum value in a non numeric column,
example below
Answer needed is IT20140010
IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006
IT20140007 IT20140008 IT20140009 IT20140010
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP
use a helper column to convert the data (to numeric) and then apply Max
formula you shall get the answer..
Hope this helps​
On Thu, Oct 9, 2014 at 3:54 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Please help me in finding the maximum value in a non numeric column,
> example below
>
> A
Hi Frd,
=max(substitute(cellvalue ya cell reference,"IT","",1))
Try kro bhai
On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote:
> Dear Friends,
>
> Please help me in finding the maximum value in a non numeric column,
> example below
>
> Answer needed is IT20140010
>
>
> IT20140001 IT20140002 IT2
Hi,
Assuming yours values are in range A1:A10, you need to enter the following
as an Array Formula
=MAX(--RIGHT(A1:A10,8))
To enter the same as an Array Formula, you need to press Ctrl+Shift+Enter
after entering the formula in the Cell.
On Thu, Oct 9, 2014 at 6:34 PM, manu kashyap
wrote:
> Hi
Friends.
I tried all your suggestions i did not got the answer
Thanks
N.Sundarvelan
9600160150
On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna
wrote:
> Hi,
>
> Assuming yours values are in range A1:A10, you need to enter the following
> as an Array Formula
>
> =MAX(--RIGHT(A1:A10,8))
>
Have a Look !
I hope you are aware of how to enter an Array Formula !
On Thu, Oct 9, 2014 at 9:07 PM, Sundarvelan N wrote:
> Friends.
>
> I tried all your suggestions i did not got the answer
>
> Thanks
> N.Sundarvelan
> 9600160150
>
> On Thu, Oct 9, 2014 at 8:14 PM, Kanwaljit Singh Dhunna <
>
Hi kanwaljit
Can u explain me how to work your formula, max right i understand but minus
why using twice!
Pls explain it i know little more array function.
On Oct 9, 2014 10:36 PM, "Kanwaljit Singh Dhunna"
wrote:
> Have a Look !
>
> I hope you are aware of how to enter an Array Formula !
>
> On
hi
double - sign converts range to array..
cheers!!
On 11/30/14, Sunil Kumar Yadav wrote:
> Hi kanwaljit
>
> Can u explain me how to work your formula, max right i understand but minus
> why using twice!
>
> Pls explain it i know little more array function.
> On Oct 9, 2014 10:36 PM, "Kanwaljit