| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting unique entries and assigning it to a named range
Hi,
I have come across the formula in Chip's page http://cpearson.com/excel/duplicat.htm#ExtractingUnique for extracting unique values. My requirement is to store the list of all unique entries from a range (let' say A1: A100) in to a Named range. Is there a formula based solution to the same? (probably using an appropriate array formula within named range dialog box). Please guide me for the same. Regards, Hari India |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Just the Unique Entries From a Range of Cells | Excel Discussion (Misc queries) | |||
| Extracting unique entries | Excel Worksheet Functions | |||
| Count unique entries in data range | Excel Worksheet Functions | |||
| Return entries from one named range based on the contents of another | Excel Worksheet Functions | |||
| Extracting unique entries and assigning it to a named range | Excel Discussion (Misc queries) | |||
Threaded Mode
