I need to average the following row of letters. Is it possible?
A B D C C C C A B D A A A A A = AVERAGE OF THIS ROW (IE B)
I need to average the following row of letters. Is it possible?
A B D C C C C A B D A A A A A = AVERAGE OF THIS ROW (IE B)
If your letters are in A2:P2 and all in upper case try
=CHAR(ROUND(SUMPRODUCT(CODE(A2:P2))/COUNTA(A2:P2),0))
This should work:
=CHAR(ROUND(AVERAGE(IF(A1:Z1<>"",CODE(A1:Z1))),0))
This is an array formula, so once you enter it, hit CTRL + SHIFT + ENTER, rather than just ENTER.
HTH
Jason
Looks like I type too slow. LOL
Hello Jason
faster doesn't always equal better
Your approach copes with blanks whilst mine doesn't
Thank you both for your input. However, i forgot to mention that these cells are retrieving the "Letter Grade" based on another sheet via VLOOKUP command.
So both do not work correctly. But I know you guys will have the answer!
note:
B4:U4 is my range we are dealing with, btw.
That shouldn't make any difference unless some of the cells return #N/A, is that the case? If not what results did you get with the above suggestions?Originally Posted by couger77
What are the possible results in B4:U4?
#VALUE! is what I am getting for a return in cell V4.
The range of letters is simply A,B, or C.
It is possible there might be an #N/A (will fix later) or blank in any given cell.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks