consolidating data in an excel worksheet
 

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.

consolidating data in an excel worksheet
 

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

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:D)

Hope this helps.

Pete

On Jul 29, 11:19*am, potman wrote:
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.