Average as Text

[johncon]

I have lot of rows that have the values of either A,B,C or D I need to get the average of these rows in a seperate column but in a text value.

Hope this makes sense

Any help would be appreciated

Regards
Johncon

[sweep]

Hi,

I think this is what you need.

If your data is in column A,

=CHOOSE(ROUND((COUNTIF(A:A,"A")+2*COUNTIF(A:A,"B")+3*COUNTIF(A:A,"C")+4*COUNTIF(A:A,"D"))/COUNTA(A:A),0),"A","B","C","D")

will produce the "average"

[johncon]

Thanks

I have adapted it to rows.
=CHOOSE(ROUND((COUNTIF(C13:R13,"A") +2*COUNTIF(C13:R13,"B") +3*COUNTIF(C13:R13,"C")+4*COUNTIF(C13:R13,"D"))/COUNTA(C13:R13),0),"A","B","C","D")

But this still does not give the averages.

If I have all 16 columns as "D" then the average is "D" but if i change 2 columns to "A" then the average changes to "C"

as you can see this in not quite right.

Cheers
JohnCon

[johncon]

Dave

My apologies

I have just run the same thing as numerical values and it is correct, it just did not look right

Many thanks again for your help

[sweep]

No worries. I'm glad it worked.