Link to home
Start Free TrialLog in
Avatar of mabarnes11
mabarnes11Flag for United States of America

asked on

Create a worksheet with list of rows containing "#N/A."

I have a spreadsheet consisting of two worksheets.  The first is a complete roster of names.  The second is a list of those scheduled for various positions for a given month.  I would like to create a third sheet with a list of those who are not scheduled.  I have created a column on the complete list using VLOOKUP and have identified those who are not scheduled.  How can I pull only those with #N/A in column with the VLOOKUP formula (those who are not scheduled) to a third worksheet?
Thanks in advance.
Avatar of Peter Kwan
Peter Kwan
Flag of Hong Kong image

Any sample for us to work on?
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial