Needing help with creating report for comparison of sales data over two
periods.
Existing sample data is as follows:

(DECEMBER 2004)
A1=AGENT CODE
B1=AGENT NAME
C1=BOOKING
D1=SALES

A1:A500 DATA FIELDS

(DECEMBER 2005)
F1=AGENT CODE
G1=AGENT NAME
H1=BOOKING
I1=SALES

F1:I500 DATA FIELDS

What I need is a simple Comparison Table sitting to the right of the two
data feilds

K1=AGENT CODE
L1=AGENT NAME
M1=CHANGE IN BOOKINGS
N1=CHANGE IN SALES
O1=CHANGE IN SALES (PERCENTAGE)

Because of new and cancelled agents, the order that the sales data appears
is all over the place. I need the Comparison table to be able to firstly
match up agent codes (ie K1 & A1). If there is no match for K1, then print
"NEW AGENT" in the N1 fields. If no match up with A1, then print "CANCELLED
AGENT" in the same field. If there is a match up between the two, calculate
fields for M1, N1 and O1.

Hope this makes sense. I'm still very much a novice with this stuff. Any
help is greatly appreciated.

Rgds
GP

GP
Have your read following link
http://www.exceltip.com/images/screenshots/167.gif

HTH
norika


--
norika
------------------------------------------------------------------------
norika's Profile: http://www.excelforum.com/member.php...fo&userid=4878
View this thread: http://www.excelforum.com/showthread...hreadid=496568