Simon Lloyd
03-25-2007, 10:58 AM
Hi all as per a previous post i have this formula which i fixed with ISERR: {=IF(ISERR(INDEX(Accounts,SMALL(IF(MATCH(Accounts,Accounts,0)=ROW(INDIRECT("1:"&COUNTA(Accounts))),MATCH(Accounts,Accounts,0),""),ROW()-ROW(Accounts)+1))),"",INDEX(Accounts,SMALL(IF(MATCH(Accounts,Accounts,0)=ROW(INDIRECT("1:"&COUNTA(Accounts))),MATCH(Accounts,Accounts,0),""),ROW()-ROW(Accounts)+1)))}
The formula works great but if the list has a gap in it all of the other values it returns when copied down show#N/A, does anyone know how to cure this?
Regards,
SImon
The formula works great but if the list has a gap in it all of the other values it returns when copied down show#N/A, does anyone know how to cure this?
Regards,
SImon