Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning an array of unique values?
Is there anyway, using a formula, to return an array of unique values
extracted from a larger array that has duplicate values. The resulting array would be used for further calculations in the rest of the formula? Likewise, is there anyway to use the values (true, false) in one array to determine which values are selected out of another array for creating a resulting array to be used for further calculations in the formula? Can an array be sorted within a formula before using it in the balance of the formula? I am able to generate an array including all the values I need, but I cannot get rid of the duplicate values in that array. Thank you for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning an address from an array | Excel Discussion (Misc queries) | |||
Matching numbers in an Array and returning values for matched numb | Excel Discussion (Misc queries) | |||
Array formula for unique values | Excel Worksheet Functions | |||
Array formula for unique values | Excel Worksheet Functions | |||
Need to be done in 2 hours!!!! VLOOKUP returning #REF for unique I | Excel Worksheet Functions |