Filter by formula

M

Michel

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
 
S

Steve Dunn

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top