ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Floating Name Ranges?? (https://www.excelbanter.com/excel-discussion-misc-queries/205593-floating-name-ranges.html)

Jeff

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