Help in resoloving scenario

[Tarek]

help with formula
I hope I can get help with the mention below scenario:

let's say:

ColumnA--------ColumnB----------------ColumnC
SalesRep-------Country------------------Value
Mike-------------Italy-----------------------$20,000
Jane-------------Italy-----------------------$20,000
Nadia------------Spain---------------------$10,000
homas-----------Spain---------------------$10,000
Eric---------------Germany, Austria-------$7,000 (austria=2,000)
Mary-------------Finland--------------------$200
Rami-------------England------------------$500
Ravi--------------Germany-----------------$5,000
Derek------------Romania, Poland------$6,000 (poland - 5,000)
adeem-----------Romania----------------$1,000

The logic behind the scenario is to calculate: total countr
performance (with out calculating the same country twice) also sinc
assignments of sales rep changes every quarter, formula should not us
the sales rep as a reference.

Currently I am adding the countries manually! Is it possible to creat
a formula for that?


Many Thanks in advance,
Tare

 

[Frank Kabel]

Hi
first: Please don't multipost. You already posted this question so
please stay in the original thread

second: I'd try the following:
- use a pivot table with your country as row item and the maximum of
your value as data item. this should produce a country report with only
one value per country