Posted to microsoft.public.excel.misc

Richard

external usenet poster

Posts: 709

Comparing Spreadsheets

I need to merge two spreadsheets based on customer#. What would be the
easiest way to do this without VB?

My biggest problem is that I have not been able to confidently determine if
each spreadsheet has all the relevant customer #s. Is there a function in
Excel that can compare the two lists and tell me if any customers are missing?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Comparing two spreadsheets part 2	Freddo	Excel Worksheet Functions	10	May 4th 06 07:27 PM
Comparing two spreadsheets	Freddo	Excel Worksheet Functions	2	May 2nd 06 11:40 AM
Comparing two spreadsheets	Morten	Excel Worksheet Functions	1	October 21st 05 02:30 PM
comparing 2 spreadsheets	Danny	Excel Discussion (Misc queries)	3	July 11th 05 12:56 PM
Comparing Spreadsheets	HankHarris	Excel Worksheet Functions	1	January 4th 05 09:13 PM

All times are GMT +1. The time now is 06:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us