Posted to microsoft.public.excel.worksheet.functions

henriques

external usenet poster

Posts: 13

Comparing Data

I have data for 2 different months.
I need a formula or macro that creates a column with all data included in
both months sorted by column A.
See example

A B C D E F
Jan Feb. All
code value code value code value
a1 3 a1 5 a1 5
a2 5 a3 12 a2 5
a3 9 a4 6 a3 12
a5 2 a7 2 a4 6
a6 3 a8 10 a5 2
a8 6 a6 3
a7 2
a8 10

How to manage this
Thanks a lot
AntÃ³nio

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 data	Abas Ibrahimov	Excel Worksheet Functions	2	September 28th 06 07:04 AM
Comparing Data	zephyr	Excel Discussion (Misc queries)	2	February 23rd 06 03:39 PM
help comparing two sets od data to find the odd data	matsgullis	Excel Worksheet Functions	2	January 12th 06 01:52 AM
comparing lists of data to remove duplicate data	Tom	Excel Discussion (Misc queries)	2	October 13th 05 06:16 PM
Comparing data in two columns and highlighting the data	David Kinsley	Excel Worksheet Functions	6	January 4th 05 06:01 PM

All times are GMT +1. The time now is 01:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us