General discussion


Comparing mutiple columns in Excel 2000

By ezrab_m ·
I need to compare- and show in a new column- columns of hundreds of records. I can do this using filter for 2 columns, but not for three or more.
Is there a solution for this, using Excel's functions?
Thanks (

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

bit more info

by Paul Gowen In reply to Comparing mutiple columns ...

sorry it is early, please explain more or give an example, been a while since i have worked with excel, i'll give it a go

Collapse -

Columns to compare

by ezrab_m In reply to bit more info

I have different versions of school exercise books. I then copy/paste the questions on each page and need to verify which exercises- or parts of exercises- are common.
example, where each letter represents a word:
take 5 pies; let 5 pies; If the sun sets;
7 donkeys carry; 7 donkeys carry; the moon rises;
The sun sets at 9.00; 10 men work; A loaf is;
The resulting new column should then read:
take 5 pies
let 5 pies
If the sun sets
The sun sets at 9.00

A Web search using different search engines using the same term is another example, transferring the results to an excel file for comparison.
If you can help, great. Anyway, thanks Paul

Collapse -


by Paul Gowen In reply to Columns to compare

sorry for slow reply, been on me annual hols for past few weeks, i will have a think about that, i think i understand what your getting at, so thats a start i suppose!

Related Discussions

Related Forums