P
Phunnybonz
Unfortunately there is other data in that column.
Here's what I'm doing. I'm taking all data in Colmn B (as an example
and using this in a query to return results that meet certain criteria
These results are then put into Colmn A. All data in Colmn A IS in Colm
B, but not all data in Colmn B is in A. Then I match up with conditiona
formatting to identify the data in B that fell out of my query.
More often than not, one or more columns can contain data that exceed
10,000 rows so it isn't always easy to quickly identify th
differences
Here's what I'm doing. I'm taking all data in Colmn B (as an example
and using this in a query to return results that meet certain criteria
These results are then put into Colmn A. All data in Colmn A IS in Colm
B, but not all data in Colmn B is in A. Then I match up with conditiona
formatting to identify the data in B that fell out of my query.
More often than not, one or more columns can contain data that exceed
10,000 rows so it isn't always easy to quickly identify th
differences