Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding unique entries in a column
I have a range of cell entries,
Worksheets(Sheet1Name).Range(Cells(Sheet1FirstRowN um, _ Sheet1RespCodeColPointer) & ":" & Cells(Sheet1LastRowNum, _ Sheet1RespCodeColPointer)) in which I need to: 1) count the number of unique entries and store the result in a variable 2) copy each of the unique entries that were found to an array, and then refer to each entry in the array in a subsequent formula Any help in showing me how to perform these 2 steps would be greatly appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding unique entries among two columns of alphanumeric data | Excel Worksheet Functions | |||
Finding Unique Entries Among Two Columns | Excel Programming | |||
Finding Unique Entries Among Two Columns | Excel Programming | |||
Finding Unique Entries Among Two Columns | Excel Programming | |||
Restrict a column to allow only unique entries? | Excel Programming |