Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically extracting unique values
We need to extract the unique values from a range and have them copied to
another range. However, we are looking for a solution that will transparently keep the unique destination range values updated as the source range values change. Is this possible? Is there some formula or array formula that will extract the unique values from another range and keep them updated as they change? If not, is there a simple macro that could perform the job and be automatically triggered by cell edits to the source range? Our goal is to extract the unique account numbers from a large list of transactions and then summarize the transaction subtotals for any given account number. We are open to any ideas, thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting unique values from a list using VBA | Excel Discussion (Misc queries) | |||
Automatically extracting unique values | Excel Worksheet Functions | |||
Extracting unique values from live list | Excel Programming | |||
Populate a column by extracting unique values from another column? | Excel Worksheet Functions | |||
extracting unique values with a formula or with vba | Excel Programming |