Hi
I have a cell that reads the student's average from another cell. I use =$B$70 and the average from the B70 cell appears here.
Is there a way to have TEXT and this dynamic average appear in the same cell so the student name and THEIR average (which changes depending on how B70 changes)...