consolidating data in an excel worksheet

[potman]

how can i make this:

JUNE 2008 JULY 2008
Advertiser Real Players Advertiser Real Players
9235 0 17 0
12345 0 9235 0
24168 20 12345 0
Mar-77 0 24168 10
32271 0 32271 0
69911 0 40502 0
70434 0 69911 0
78309 0 70434 0
100105 0 78309 0
112233 0 100105 0
121212 0 121212 0
123830 0 123830 0
130295 0 130295 0
161718 0 161718 0
175739 0 175739 0
____________________________________________________________________
into this:

Advertiser JUNE 2008 JULY 2008
XXX XXX XXX

Note: worksheet contains 10,000 rows, some advertisers in JUNE are not in
JULY stats & vice-versa. what i want to do is consolidate the advertisers in
columnn A without repeating anyone of them with corresponding JUNE & JULY
stats to get the variance per advertiser and i have to do it as fast as i
could to meet the deadline. can anyone help me on this, thanx.

 

[Pete_UK]

You can obtain a unique list of advertisers on a separate sheet by
using advanced filter - Debra Dalgleish shows how here:

http://www.contextures.com/xladvfilter01.html

(scroll down to Filter Unique Records). Then to obtain the spend for
each advertiser you can use a SUMIF formula like this in B2 of the
summary sheet:

=SUMIF(Sheet1!A:A,$A2,Sheet1!B:B)

and copy this down for June. A similar formula for July would be:

=SUMIF(Sheet1!C:C,$A2,Sheet1!D)

Hope this helps.

Pete