Unique values

[ksel]

Hi,
I have a list of container shipments to different countries, 1 line per
invoice:
France 1
Belgium 2
Spain 4
France 3
Belgium 4
In the reporting, it counts the total per destination: 4 to France, 6 to
Belgium, 4 to Spain.
To do that, I type "France" and then all containers with that destination
are counted. Is it possible to avoid the typing, so that if a new destination
is added (Brazil 5), "Brazil" is seen as new to the list and copied in the
reporting?
Thanks a lot,
Kristoff

 

[Simon Lloyd]

Without more to go on, like are you using code for this task? what i
the code? or even better a sample workbook then we will have troubl
answering, for further help with it why not join our forums (shown i
the link below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :

Hi
I have a list of container shipments to different countries, 1 line pe
invoice
France
Belgium
Spain
France
Belgium
In the reporting, it counts the total per destination: 4 to France,
t
Belgium, 4 to Spain
To do that, I type "France" and then all containers with tha
destinatio
are counted. Is it possible to avoid the typing, so that if a ne
destinatio
is added (Brazil 5), "Brazil" is seen as new to the list and copied i
th
reporting
Thanks a lot
Kristof

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Harlan Grove]

I have a list of container shipments to different countries, 1 line per
invoice:
France 1
Belgium 2
Spain 4
France 3
Belgium 4
In the reporting, it counts the total per destination: 4 to France, 6 to
Belgium, 4 to Spain.
To do that, I type "France" and then all containers with that destination
are counted. Is it possible to avoid the typing, so that if a new destination
is added (Brazil 5), "Brazil" is seen as new to the list and copied in the
reporting?

If the table of invoices were named INVOICE_TBL and the top-left cell
in the results range were E2, one approach would be

E2:
=INDEX(INVOICE_TBL,1,1)

E3 [array formula]:
=IF(SUM(F$2:F2)<SUM(INDEX(INVOICE_TBL,0,2)),INDEX(INVOICE_TBL,
MATCH(0,COUNTIF(E$2:E2,INDEX(INVOICE_TBL,0,1)),0),1),"")

Fill E3 down as far as you think you'll need it.

F2:
=IF(E2<>"",SUMIF(INDEX(INVOICE_TBL,0,1),E2,INDEX(INVOICE_TBL,0,2)),"")

Double click on the fill handle to fill it down into the same rows as
there are formulas in col E.