displaying missing data by comparing two sets

S

Shu of AZ

In the first set of 3 columns, abc, how do I pull only the rows with a '1' in
the first col and display the data in another col such as E. After that is
seperated from the first set of data, I have another set of data that is that
same information but some are missing ( In this example lets say I only have
Anderson and Winn and they may be in opposite order, Winn then Anderson in a
different col on the sheet ). I'm trying to display the ones that are
missing in another area somehow by comparing the two sets. Problem too is
that every set of data that comes in may have varying amounts of 1's 2's 3's
etc. In this case there happen to be 7 1's. So I have 2 of 7 and I need to
display the 5 which are missing on another sheet. I will have to then do it
for the 2's in col A.

( I have this ) ( I have this
)
a b c d e f g h i
j k L

1 Anderson 1 1 Winn 5b
1 Shuman 2 1 Anderson 1
1 Smith 3
1 Shehan 4
1 Winn 5b
1 Beaul 6
1 Anne 7
2 Matt 1
2 Holloman 2
2 Dane 3
2 Justar 4a
2 Pendleton 5
2 Benton 6
etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top