FANTASTIC ITS WORKING % HURRAY
Thanks Lalit and Raj for the assistance
On Wed, Jun 27, 2012 at 2:46 AM, Lalit_Mohan wrote:
> Dear Hilary
>
> Try this in column O4
>
> =IF(LARGE(($L$3:$L$21>=IF($K$23 =
> "",$L$23,$K$23))*(IF($K$23="",TRUE,$L$3:$L$21
> <=$L$23))*($L$3:$L$21),ROW($A1)) = 0, "", LAR
Dear Hilary
Try this in column O4
=IF(LARGE(($L$3:$L$21>=IF($K$23 =
"",$L$23,$K$23))*(IF($K$23="",TRUE,$L$3:$L$21
<=$L$23))*($L$3:$L$21),ROW($A1)) = 0, "", LARGE(($L$3:$L$21>=IF($K$23 =
"",$L$23,$K$23))*(IF($K$23="",TRUE,$L$3:$L$21
<=$L$23))*($L$3:$L$21),ROW($A1)))
it's an array formula
Hi HIlary,
In L25 =
=INDEX(D1:D22,LARGE(--(D3:D22>=K23)*--(D3:D22<=L23)*ROW(D3:D22),ROW(INDIRECT("1:"&SUM(--(D3:D22>=K23)*--(D3:D22<=L23),1)
with CSE
in
K25
=INDEX($C$3:$C$22,SMALL(IF($D$3:$D$22=L25,ROW($C$3:$C$22),""),COUNTIF($L$25:L25,L25))-2)
with CSE
HTH
On Wednesday, 27 Ju