question:

using the provided file

$1.$ Please use dynamic arrays to combine the cells with first name $,$ middle and last into a single array.

$2.$ using the UNIQUE, FILTER and SUM functions, tell me what degree each person is matruculated in and how many are in each degree.

$3.$ using the XLOOKUP function, write a formula that will scan the first names, return the last names, with a wildcard after the letter $"$D$".$ Set it up so it can be changed to a different letter.

What I have so far:

$($note that the middle and last names are blacked out because they are the names of myself and my classmates.$)$ I need help with part $2$ and $3.$ specifically how to do it with the functions that are given.