|
|
#1
05-04-2023, 09:12 AM
|
|||
|
|||
Return string of matched occurrences
I have a workbook with two worksheets. One contains a list of classes (a number value, which may be a decimal like 34.5) and the names of the students. The other has notes on the students.
In the second worksheet I would like to have a column that shows the classes in which the student has participated (see Column-E in the example image). The class number and names are usually sorted in ascending order. It would be good, but not required, if this were not a dependency on any formula working. I'd prefer not to use VBA, if at all possible. Is this possible, and if so then how? Thanks in advance, Andrew 
|
|
#2
05-04-2023, 02:45 PM
|
|||
|
|||
Never mind. I found a solution to my problem. I was unaware of the TEXTJOIN function.
|
|
#3
05-04-2023, 11:22 PM
|
||||
|
||||
Hi
please mark thread as "solved". Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Transpose data form columns in rows matched with a key | Alex1s85 | Excel | 7 | 11-26-2020 01:34 AM |
 How to return the full string (entire word) when searching with wildcards in word vba
|
scienceguy | Word VBA | 13 | 03-23-2019 03:27 AM |
|
find a set of characters in a string and return a 0 (zero) if not found
|
MaineLady | Excel | 2 | 11-05-2015 03:23 PM |
|
How to get the Right function to return a string that has UPPERCASE letters only
|
adj | Word VBA | 9 | 08-30-2014 09:21 PM |
| Error: The Name Could Not be Matched to a Name in the Address List. | Shawn76 | Outlook | 0 | 04-07-2010 08:32 PM |
Windows 10 
Office 2016
Linear Mode
