Req: Formula Array.....

[Cameron]

Hi all,
Have an XLS and trying to generate stats from it.
On one Worksheet I would like to break up stats in the following manne
(for example)..
Code
-------------------

Ongoing Closed
July Client Praises ?? ??
Complaints ?? ??
Vendor Praises ?? ??
Complaints ?? ??
Partner Praises ?? ??
Complaints ?? ??

The data contained on another Worksheet is in the following format:

Col#01 - Date (Format: `dd - mmm - yy`)
Col#02 - Type (Either: `Compliment` -or- `Complaint`)
Col#03 - Sender }\
Col#04 - Receiver }>>> not being used in stats.
Col#05 - Comments }/
Col#06 - `Client` / `Vendor` / `Partner`
Col#07 - Status (Either: `Ongoing` -or- `Closed`
-------------------

What I'm trying to do, is count the number of `Compliment` -or
`Complaint` instances being either `Ongoing` -or- `Closed`; aligned t
respective `Client` / `Vendor` / `Partner` instances for a particula
month.

I've figured I'd need to create an array formula, but have little ide
where to start in developing it.

Any help or requests to expand explaination further appreciated

 

[Frank Kabel]

Hi
this sounds more like using a pivot table for this kind of
analysis. Have a look at:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

-----Original Message-----
Hi all,
Have an XLS and trying to generate stats from it.
On one Worksheet I would like to break up stats in the following manner
(for example)...
Code:

Praises ?? ??