Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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...?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Floating Text Box help | Excel Worksheet Functions | |||
Floating row? | Excel Discussion (Misc queries) | |||
Floating Key | Excel Discussion (Misc queries) | |||
Floating Total Row | Excel Worksheet Functions | |||
Floating Toolbar | Excel Discussion (Misc queries) |