Re: $$Excel-Macros$$ Max Array Formulla

2013-11-04 Thread Ali Abbas
Ok boss I will share the file with you but I cannot use the Pivot Table in this my work situation. On Nov 4, 2013 3:15 PM, "ashish koul" wrote: > why don't u use pivot table also can u share a sample file > > > On Mon, Nov 4, 2013 at 8:33 PM, Ali Abbas wrote: > >> I need a maximum array formu

Re: $$Excel-Macros$$ Max Array Formulla

2013-11-04 Thread ashish koul
why don't u use pivot table also can u share a sample file On Mon, Nov 4, 2013 at 8:33 PM, Ali Abbas wrote: > I need a maximum array formula which can calculate maximum value in a > single column, but any unique value repeated again and again in the column. > Need is if "a" comes 5 times ,"b"

$$Excel-Macros$$ Max Array Formulla

2013-11-04 Thread Ali Abbas
I need a maximum array formula which can calculate maximum value in a single column, but any unique value repeated again and again in the column. Need is if "a" comes 5 times ,"b" comes 7 times than this formula calculate highest value of "a" and "b"which are in single column. Plz plz -- Are you