Compare columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

I'm trying to use either a macro or conditional formatting to compare two
sets of data. the two sets of data each have 3 corresponding columns and i
need to separate out the rows which occur in both andj the rows that occur in
just one set of data. i have found a post which does this comparing two
columns of data using conditional formulas with a countif function, this
works with one column but i cant get it to work with three columns. is there
a way around this or am i better using a macro?

any help would be much appreciated

Thankyou

Patrick
 
Hi Patrick

I do a lot of data comparison / reconciliation. The best way to do this is:

1. Manipulate your data so that is in a form that a pivot table can anlyse it
2. Create a pivot table based on your manipulated data

Data manipulation is generally easiest done in Access (or any other RDBMS)
with union queries and then copy the data into excel to use as the basis for
your pivot

This process can be automated if necessary.

If you send me an email ([email protected]) I will send you an
example of what I am talking about
 
You must log in or register to reply here.

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

Similar Threads

Excel Comparing two columns 1
Comparing two columns 7
comparing two columns in vba 2
Comparing numbers 1
Comparing to tables of data to confirm they are the same or not 2
Compare worksheets to copy and paste data based on matching criter 1
Compare two workbooks and hi-light matches 0
Match 2 set data and combine to 1set 2

Back
Top