Forum home » Delegate support and help forum » Microsoft Excel Training and help » Concatenation and selecting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Concatenation and selecting
Resolved · Medium Priority · Version 2010
Reply Wed 1 Feb 2012, 14:38Gavin (guest) said...
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
For upcoming training course dates see: Pricing & availability
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
|