From: Michel on
Hi max

Thks for your help but I tried it today but it don't work. In fact I have
two workbooks. One is the database file with a list of informations I have
listed previously and the other workbook is the report which is generated by
sumproduct to extract informations in the database workbook. Here is a
specimen of the workbook report
SPAIN Room Bed rate total
NGT SOLD Ngt Sold"

ANGALIA - -
CONCORDE TRAVEL AGENT 3 6
DIMENSIONS VIAJE CON IMAGINACI - -
DIMENSIONS VIAJE CON-MUNDICOLO - -

The name spain is the country located in cell a3 and the agency is generated
when I put the name spain. Is there a formula which will list the agency name
once as the datase consist of repeated agency name and country as well. Thks
for your help
--
Michel

From: Steve Dunn on
Michel, I would advise you to reply to the post that tried to help you
previously, that way everyone can see what has already been attempted.


"Michel" <Michel(a)discussions.microsoft.com> wrote in message
news:FBF0BE65-2F1F-4EE8-8B9B-42C561F1C0DE(a)microsoft.com...
> Hi max
>
> Thks for your help but I tried it today but it don't work. In fact I have
> two workbooks. One is the database file with a list of informations I have
> listed previously and the other workbook is the report which is generated
> by
> sumproduct to extract informations in the database workbook. Here is a
> specimen of the workbook report
> SPAIN Room Bed rate
> total
> NGT SOLD Ngt Sold"
>
> ANGALIA - -
> CONCORDE TRAVEL AGENT 3 6
> DIMENSIONS VIAJE CON IMAGINACI - -
> DIMENSIONS VIAJE CON-MUNDICOLO - -
>
> The name spain is the country located in cell a3 and the agency is
> generated
> when I put the name spain. Is there a formula which will list the agency
> name
> once as the datase consist of repeated agency name and country as well.
> Thks
> for your help
> --
> Michel
>

 | 
Pages: 1
Prev: SUMIF division
Next: Totaling text cells