Median of character values

[MartinL]

I have a sheet where I need to find the average score over time for a category
the only scores available are "D", "P", "L" & "M"

In order to take anomalies out of the equation I think I need to count all scores and display only the Score that has the highest count, I'm not sure what I will do with any duplicate highest scores yet

Can anyone point me in the right direction....

Sheet1

*	A	B	C	D	E	F	G	H
Student Name	Term 1	Term 2	Term 3	Term 4	Term 5	Term 6	Expected Answer
Student 1	P	D	D	P	D		D

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[MartinL]

Re: Mode of character values

I have a sheet where I need to find the average score over time for a category
the only scores available are "D", "P", "L" & "M"

Actually I think this is Mode not Median

 

[MARZIOTULLIO]

Re: Mode of character values

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Student Name[/TD]
[TD]Term 1[/TD]
[TD]Term 2[/TD]
[TD]Term 3[/TD]
[TD]Term 4[/TD]
[TD]Term 5[/TD]
[TD]Term 6[/TD]
[TD]Expected Answer[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Student 1[/TD]
[TD]P[/TD]
[TD]D[/TD]
[TD]D[/TD]
[TD]P[/TD]
[TD]D[/TD]
[TD][/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]


h2=INDEX(B2:G2,MODE(IF(ISTEXT(B2:G2),MATCH(B2:G2,B2:G2,0)))) control+shift+enter

 

[MartinL]

Re: Mode of character values

Ohhhhh, that's cool..... Thanks MARZIOTULLIO