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)
This conversation is currently closed to new comments.
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
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!
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Comparing mutiple columns in Excel 2000
Is there a solution for this, using Excel's functions?
Thanks (ezrab_m@hotmail.com)