Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I was wondering if this is possible:
Assume you have two columns of data: Sales Rep and Quarterly Sales. The sales rep field contains only unique values. What I want to do is to write a formula that will list the names of each sales rep that has quarterly sales of some value or greater, say $2500. If I write a standard sum array formula and evaluate the formula on numeric data, I can see that excel stores a list of values, but I cannot figure out how to have Excel list those values separately in a single cell. Is this possible? Thanks, D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting more than one lookup results in array | Excel Worksheet Functions | |||
Exclude 0 from MIN array results | Excel Discussion (Misc queries) | |||
array results not returned | Excel Worksheet Functions | |||
Creating a concatenate text list by referencing an array | Excel Discussion (Misc queries) | |||
Array with multiple results | Excel Worksheet Functions |