Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering formula in a numeric array
Hi
I need to use the "percentile" function for an array. The array is not stored in a range of cells, but it is a set of numbers, so I guess I need to enter them in curly brackets. If I enter the numbers themselves, e.g. {1,2,3} it works fine, however, I want the set of numbers to be found by vlookups, e.g. {vlookup(...),vlookup(...)} and this way it doesn't work. Does anyone have an idea how to make it work (without using other cells)? Thank you and have a nice day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
SUMPRODUCT clue needed | Excel Discussion (Misc queries) | |||
Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |