result required for large 20,17 and 16 which is not done through this
formula.
On Tuesday, April 19, 2016 at 3:51:31 PM UTC+5:30, amar takale wrote:
>
> Array formula press (Ctrl+Shift+enter)
>
> ={LARGE($A$2:$A$21,{1;2;3;4;5})}
>
> On Tue, Apr 19, 2016 at 3:50 PM, amar takale > wrote:
>
>> use
Array formula press (Ctrl+Shift+enter)
={LARGE($A$2:$A$21,{1;2;3;4;5})}
On Tue, Apr 19, 2016 at 3:50 PM, amar takale wrote:
> use this formula
>
> =LARGE($A$2:$A$21,{1;2;3;4;5})
>
> On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal
> wrote:
>
>> Dear Sir
>>
>> Required formula for top 3 unique v
use this formula
=LARGE($A$2:$A$21,{1;2;3;4;5})
On Tue, Apr 19, 2016 at 3:21 PM, Rajesh Agarwal wrote:
> Dear Sir
>
> Required formula for top 3 unique value & bottom 3 unique value excluding
> "Zero".
>
> On Sun, Apr 17, 2016 at 7:06 PM, Rajesh Agarwal
> wrote:
>
>> Hello Sir
>>
>> formula re
Dear Sir
Required formula for top 3 unique value & bottom 3 unique value excluding
"Zero".
On Sun, Apr 17, 2016 at 7:06 PM, Rajesh Agarwal wrote:
> Hello Sir
>
> formula required for top 3 value and lowest 3 value's in attached sheet.
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
--
*Raj
