Apply data|filter|autofilter to column B.
Filter to show the #n/a's.
Select those visible rows
edit|copy
then off to the new location
edit|paste


Sheila wrote:

I have a list that looks like this:
Column A Column B
02941842 34,939.55
02941840 34,939.55
03062084 #N/A
02657582 30,203.20
03126311 #N/A
03105157 28,430.54

I need a seperate summary list that extracts the items from Column A with an
error in Column B. Can excel do this?

--

Dave Peterson