Thread: Extract list of units based on error criteria to new list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Extract list of units based on error criteria to new list
In D1:
=IF(ISERR(SMALL(IF(ISERROR(rangeB),ROW(INDIRECT("1 :"&ROWS(rangeA)))),ROWS($1:1))),"",INDEX(rangeA,SM ALL(IF(ISERROR(rangeB),ROW(INDIRECT("1:"&ROWS(rang eA)))),ROWS($1:1))))

ctrl+shift+enter, not just enter
copy down

In E1: =IF(D1="","",VLOOKUP(D1,ranges,2,0))
copy down

"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?
Reply With QuoteReply With Quote