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
|