Excel Problem

  • Thread starter Thread starter Brian Fitzgerald
  • Start date Start date
B

Brian Fitzgerald

I have a problen with an Excel spreadsheet I hope SKS is able to help
me with.


In column A I have a list of numbers in A2:A564
In column B I have another list of numbers in B2:B796 with have names
and addresses etc in columns C throu F

The problem

I need to extract from the list in column B (with the names addresses
etc) all the numbers that do not appear in the list in column A

The list of numbers is in numerical order in both columns

Any help and advise would be greatly appreciated

Thanks

Brian Fitzgerald
 
Brian Fitzgerald said:
In column A I have a list of numbers in A2:A564
In column B I have another list of numbers in B2:B796 with have names
and addresses etc in columns C throu F

The problem

I need to extract from the list in column B (with the names addresses
etc) all the numbers that do not appear in the list in column A

The list of numbers is in numerical order in both columns
Click to expand...

The order in each column doesn't matter for this sort of problem.

Use column G as another 'field'. If you don't already have field names or
column headings in row 1, you'll need to insert a row and put some in for
columns B through F. I'll assume you already have them in row 1.

In G1 enter 'Indicator' (without the single quotes). In cell G2 enter the
formula

=COUNTIF($A$2:$A$564,B2)

Fill G2 down into G3:G796. Select B1:G796. Run Data > Filters > AutoFilter.
Set column G to display only zero values. The resulting rows have no matches
for column B values in column A. Copy the filtered range, and paste into a
different worksheet or well below the filtered range in the same workbook.
This will paste only the filtered rows.
 
Back
Top