Desktop

Ask something
Discussion Locked

Comparing mutiple columns in Excel 2000

0 helpful
3 replies

by ezrab_m

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 (ezrab_m@hotmail.com)

3 replies

by Member 19528012

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

by ezrab_m

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
ezrab

by Member 19528012

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!

This discussion is closed to new replies.