Thank you Mathaibhai.thank you very much for help..
On Nov 16, 9:15 pm, Sam Mathai Chacko wrote:
> Hi Nemi,
>
> Here's one way to do it.
> *
> For your first table
>
> =SMALL($A$21:$A$32,COUNTA($A$21:$A21))
> =INDEX($B$21:$B$32,SMALL(IF(($A$21:$A$32=$D21),ROW(INDIRECT("1:"&ROWS($A$21:$A$32)))
Hi Nemi,
Here's one way to do it.
*
For your first table
=SMALL($A$21:$A$32,COUNTA($A$21:$A21))
=INDEX($B$21:$B$32,SMALL(IF(($A$21:$A$32=$D21),ROW(INDIRECT("1:"&ROWS($A$21:$A$32))),""),COUNTIF($D$21:D21,D21)))
* as CSE formula
*For your second table*
*
=IFERROR(INDEX($B$2:$B$14,SMALL(IF(($C$2:$
Please help me sorting the data.
--
Nemi Gandhi
98204 92963
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention
