Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

List array results as text

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
D_at_IBM - 11 Mar 2008 23:29 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.