If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter by formula
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 |
#2
|
|||
|
|||
Filter by formula
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|