View Single Post
  #1   Report Post  
Werner Rohrmoser
 
Posts: n/a
Default create an array with unique items IN MEMORY

Hello,

in the usegroup there are many postings describing how to get
an array of unique items listed on a spreadsheet.

I have the following formula:
{=SUM(--(SUMIF(Months,{"Jan","Feb","Mar"},Values)0))}

I'd like to replace the array constant "{"Jan","Feb","Mar"}"
by an formula which creates an array of unique items from
a range which I've called "Months".

Regards
Werner