Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that will constantly updated by customers. I want to
create a formula to automatically summarize a list of various components. For example: Column A Column B Material 1 Thickness 1 Material 1 Thickness 2 Material 2 Thickness 1 Material 1 Thickness 1 I want a formula on the spreadsheet to summarize this data so that it will produce a list as follows: Column A Column B Material 1 Thickness 1 Material 1 Thickness 2 Material 2 Thickness 1 Many thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup to create a list from a larger list | Excel Discussion (Misc queries) | |||
Create summarized list from larger list | Excel Discussion (Misc queries) | |||
Automatically Deleting a List from Another (Larger) List | Excel Discussion (Misc queries) | |||
Producing an automated list from a larger list | Excel Worksheet Functions | |||
Drop-down list Populated by a Subset of a larger list | Excel Worksheet Functions |