View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
D_at_IBM D_at_IBM is offline
external usenet poster
 
Posts: 1
Default 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