M
Michel
HI
I have a database with repeated informations as listed below and is
increasing daily
Nat Firm Name
SPAIN VIAJES EL CORTE INGLES
SPAIN VIAJES EL CORTE INGLES
SPAIN VIAJES EL CORTE INGLES
GREECE AMEX INTERNATIONAL- HOLLAND
GERMANY AIRTOURS INTERNATIONAL-GERMAN
ITALY DERTOUR GMBH & CO. KG
UNITED KINGDOM INTERNATIONAL TRAVEL CONNE
BELGIUM RAINBOW TRAVEL LTD
I would like to have a formula which will list the firm name once when
choosing the country. I don't want to perform it through a pivot table as I
am using the sumproduct to add the qty and amount to have a complete report.
Thks for your help
I have a database with repeated informations as listed below and is
increasing daily
Nat Firm Name
SPAIN VIAJES EL CORTE INGLES
SPAIN VIAJES EL CORTE INGLES
SPAIN VIAJES EL CORTE INGLES
GREECE AMEX INTERNATIONAL- HOLLAND
GERMANY AIRTOURS INTERNATIONAL-GERMAN
ITALY DERTOUR GMBH & CO. KG
UNITED KINGDOM INTERNATIONAL TRAVEL CONNE
BELGIUM RAINBOW TRAVEL LTD
I would like to have a formula which will list the firm name once when
choosing the country. I don't want to perform it through a pivot table as I
am using the sumproduct to add the qty and amount to have a complete report.
Thks for your help