![]() |
Floating Name Ranges??
ok, i have a data set that has nine or so columns and I am trying to assign
name ranges to a certain column in the data set. The first column of the dataset is a percentrank formula relating to a certain column in said dataset and the data is sorted so that the first column descends to zero. What i want to do is assign desciles to the data in increments of ten (10%) and assign name ranges for each descile. (ex. column D is hours, column E is $$, column G is Duration) is it possible to assign a name range to the cells in column D, E or G when column A is, for example, greater than .89 ( 1st descile),etc...?? |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com