Hi!

Is it because there are some blanks in the column B*?*

No. If a cell in column A equals E2 and the corresponding cell in column B
is EMPTY and is the first instance of EMPTY then the formula will just
return 0 for that instance. The same thing will happen if a cell in column A
equals E2 and the corresponding cell in column B is a formula blank "". The
formula will return the formula blank for that instance.

Do you have instances where column A will equal E2 and the corresponding
cell in B2 will be either empty or a formula blank?

Do you have formulas in coulmn B that are returning an #N/A error?

Biff

"vane0326" wrote in
message ...

Thank You so much Biff the formula you provided works but when I try to
expand the range I get a #N/A! error.

=INDEX(B$2:B$100,SMALL(IF(N(FREQUENCY(IF(A$2:A$100 =E$2,MATCH(B$2:B$100,B$2:B$100,0)),MATCH(B$2:B$100 ,B$2:B$100,0))0)0,ROW(B$2:B$100)-ROW(B$2)+1),ROWS($1:1)))


Is it because there are some blanks in the column B*?*


--
vane0326
------------------------------------------------------------------------
vane0326's Profile:
http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=546922