List array results as text
 

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

List array results as text
 

"Excel list those values separately in a single cell" Do you mean sum the
values? If so, use SUMIF

Tyro
..
"D_at_IBM" wrote in message
...
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

List array results as text
 

How about a couple of different options.

Select your range
Data|filter|autofilter
(xl2003 menus)

Then use a custom filter to show what you want.

Or you could just sort your data by quarterly sales (descending) and sales rep.
Then the highest sales numbers will be at the top of the data.

D_at_IBM wrote:

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

--

Dave Peterson