Posted to microsoft.public.excel.misc

PauloG

external usenet poster

Posts: 4

Comparing 2 sheets

I have 2 sheets with serial numbers on them. Sheet 1 has over 19,000 serial
numbers on it and Sheet 2 has 3,000. Sheet 1 also has addresses attached to
them and Sheet 2 is simply the serial numbers. I want to compare these two
sheets and see which Serial Numbers on Sheet 2 appear in Sheet 1. I have
tried a few SUMIF and COUNTIF formulas but to no avail. I am desperate so any
would be appreciated!

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 Sheets	Pete Petersen	Excel Worksheet Functions	2	April 7th 10 10:04 PM
Sheets comparing	Saed	Excel Worksheet Functions	1	April 1st 08 07:21 AM
Comparing Across Sheets	RJB	Excel Discussion (Misc queries)	1	March 6th 08 02:23 AM
comparing 2 sheets	rodchar	Excel Discussion (Misc queries)	3	September 11th 07 03:55 AM
comparing 2 sheets	studentcog	Excel Worksheet Functions	1	February 15th 06 04:46 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us