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
Tyro - 11 Mar 2008 23:52 GMT
"Excel list those values separately in a single cell" Do you mean sum the
values? If so, use SUMIF
Tyro
.
>I was wondering if this is possible:
>
[quoted text clipped - 15 lines]
> Thanks,
> D
Dave Peterson - 12 Mar 2008 00:51 GMT
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.
> I was wondering if this is possible:
>
[quoted text clipped - 11 lines]
> Thanks,
> D

Signature
Dave Peterson