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
1	Student Name	Term 1	Term 2	Term 3	Term 4	Term 5	Term 6	Expected Answer
2	Student 1	P	D	D	P	D		D

<tbody>
</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

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

<tbody>
</tbody>

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