My guess is your list of names are NOT identical throughout your range
on the 'Quantity' tab, e.g. "4040 SL" (7 characters in name, counting
spaces) is NOT the same as "4040 SL " (13 characters, counting
spaces) check cells: A1256, 1264, 1273 and 1281 for this anomoly. Use
"=LEN(A2)" copied down, then apply your filter to find differences.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=474781