Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ellen
 
Posts: n/a
Default how to compare columns in 4 worksheets

I have someone who has 4 Excel spreadsheets with info in different columns.
Is there a way to have Excel compare all columns he chooses and hilight or
somehow indicate the fields that are the same in multiple
columns/workstheets?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using VLOOKUP to compare 2 columns to find new information Jessica Excel Worksheet Functions 3 July 19th 05 02:59 AM
Compare data on 2 separate worksheets. Wayne Excel Worksheet Functions 3 July 10th 05 04:25 AM
how do I compare columns in two different workbooks? Provider98122 Excel Discussion (Misc queries) 5 March 10th 05 03:33 AM
Compare columns PiedmontJohn Excel Discussion (Misc queries) 4 January 7th 05 12:08 AM
How do I compare 2 columns in excel from the same spreadsheet sleyden Excel Discussion (Misc queries) 1 January 6th 05 01:36 AM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"