Re: $$Excel-Macros$$ Formula to find Maximum number from list

2012-02-08 Thread The Viper
its working fine. now i have wrote two types of formulas go through the attachment. On Wed, Feb 8, 2012 at 4:53 PM, Ashish Bhalara wrote: > Maximum number is 1003, not display in your formula > > > On Wed, Feb 8, 2012 at 4:49 PM, The Viper wrote: > >> hi ashish >> >> use =MAX(--REPLACE(A2:A41,

Re: $$Excel-Macros$$ Formula to find Maximum number from list

2012-02-08 Thread Ashish Bhalara
Maximum number is 1003, not display in your formula On Wed, Feb 8, 2012 at 4:49 PM, The Viper wrote: > hi ashish > > use =MAX(--REPLACE(A2:A41,1,9,"")) with CSE > > > On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara > wrote: > >> Dear expert, >> >> I want to formula of maximum number find from

Re: $$Excel-Macros$$ Formula to find Maximum number from list

2012-02-08 Thread The Viper
hi ashish use =MAX(--REPLACE(A2:A41,1,9,"")) with CSE On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara wrote: > Dear expert, > > I want to formula of maximum number find from a different list which > example attached herewith. > > Thanks & regards > > Ashish Bhalara > > -- > FORUM RULES (986+ m