Filtering/Subtracting Data with two columns
 

I have a list of store numbers in column one, and a list of stores that i
have received surveys from in column two. How do i subtract the data from
column 1 so that i can see what stores i still need to collect surveys from?

Thanks

One way would be to use DataFilterAutofilter
Use the dropdown on the second column to select "blanks" and that will give
you the list of stores you are stillwaiting to hear from.

--
Regards
Roger Govier
"No.limit" wrote in message
...
I have a list of store numbers in column one, and a list of stores that i
have received surveys from in column two. How do i subtract the data from
column 1 so that i can see what stores i still need to collect surveys
from?

Thanks

Can you give us a few sample rows so that we can come up with a workable
solution for you?

How do you mark the surveys? Is there a check next to the store number? Is
there a date? Is there a consistent text entry?

Please give us some more help so that we can help you.

--
Cordially,

Bob Sullivan
Microsoft Office Master Instructor


"No.limit" wrote:

I have a list of store numbers in column one, and a list of stores that i
have received surveys from in column two. How do i subtract the data from
column 1 so that i can see what stores i still need to collect surveys from?

Thanks

The two columns are like this...
038 041
039 052
040 068
041 070


there are no spaces in between the numbers in column two and im just trying
to figure out which ones i am missing in column two...
"Bob Sullivan" wrote:

Can you give us a few sample rows so that we can come up with a workable
solution for you?

How do you mark the surveys? Is there a check next to the store number? Is
there a date? Is there a consistent text entry?

Please give us some more help so that we can help you.

--
Cordially,

Bob Sullivan
Microsoft Office Master Instructor

Say your data is in column A and C.

Then put this in B1 and drag down:

=if(isnumber(match(a1,C:C,0)),"Found in column C","Missing from column C")
And drag down to match the number of rows in A.

And in D1, put this formula:
=IF(ISNUMBER(MATCH(c1,a:a,0)),"Found in column A","Missing from column A")

And drag down to match the number of rows in column C.

You could even add headers and then select A:D and do Data|Filter|Autofilter.

And filter to see the ones you want.

========
You may want to read Chip Pearson's treatise on Duplicates:
http://www.cpearson.com/excel/duplicat.htm

He has lots of hints/techniques you might be able to use.


No.limit wrote:

The two columns are like this...
038 041
039 052
040 068
041 070

there are no spaces in between the numbers in column two and im just trying
to figure out which ones i am missing in column two...
"Bob Sullivan" wrote:

Can you give us a few sample rows so that we can come up with a workable
solution for you?

How do you mark the surveys? Is there a check next to the store number? Is
there a date? Is there a consistent text entry?

Please give us some more help so that we can help you.

--
Cordially,

Bob Sullivan
Microsoft Office Master Instructor



--

Dave Peterson