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. |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com