Hi Nitya,

Am Thu, 14 Apr 2016 12:10:00 +0200 schrieb Claus Busch:

try:
=SMALL(A2:A100,SUMPRODUCT((B2:B100<"")/COUNTIF(B2:B100,B2:B100&""))*2)-SMALL(A2:A100,1)+1

or use a Pivot table. That's more reliable. Have another look in
OneDrive


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional