Concatenation and selecting
Hello,
I was hoping you could point me in the right direction with this question:
from a list of results (course modules) for each student, I need to both concatenate the grades and then pick the top 3 grades for each student. So,
Mr/B/Smith/subject 1/A
Mr/B/Smith/subject 2/E
Mr/B/Smith/subject 3/C
Mr/B/Smith/subject 4/U
-then next student
so I need to concatenate: ACEU
and then chop it down to the top 3: ACE
thanks
Gavin
RE: Concatenation and selecting
Hi Gavin
Is it already concatenated or is your example above using cells A-E? If the text is in one string and all in A for example do this;
use the Text to Columns function on the data tab (ribbon), use the other option. One you have done this you can simply create table with filters and sort or even use conditional formating.
If its in cells A-E and needs contatenation which i presume is correct, and it looks like know how to do this the my question would be why no just sort first and then concatenate?
Cheers
