ExcelBanter - Extract list of units based on error criteria to new list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Extract list of units based on error criteria to new list (https://www.excelbanter.com/excel-worksheet-functions/153535-extract-list-units-based-error-criteria-new-list.html)

Sheila

Extract list of units based on error criteria to new list

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?

All times are GMT +1. The time now is 05:42 AM.