Macro to calculate freq count

[Ucpaul]

Hello,

I have a table and want to count frequency in C1 and averaged values in C2&C3. The below a an simple example of data. I appericiate your help.

Original Table
C1. C2. C3
A. 2. 1
F. 4. 3
G. 1. 2
A. 5. 3
F. 1. 4

Final table
A. 2 3.5. 2
G. 1. 2.5. 3.5
F. 2. 2.5. 3.5

[smuzoen]

To get a unique list starting in D2 of the letters in A2:A6 use an array formula Ctrl Shift Enter (row 1 is empty) and copy down

Please Login or Register  to view this content.

To get the averages then use AVERAGEIF and to get the frequency use COUNTIF
See attached workbook

[Ucpaul]

Thanks, Anthony, very much for help. Great "*"