Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unique values | Excel Worksheet Functions | |||
Count Unique Values but not Filtered or Hidden Values | Excel Worksheet Functions | |||
Unique Values | Excel Discussion (Misc queries) | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions |