Forum Discussion
Trumpetnut
May 07, 2024Copper Contributor
Output names to a grid comparing two data points
Hi I have a table with columns for student names and assessment scores for multiple assessments, each graded 1 to 9. I also have a tracking table where grades for one assessment go horizontally an...
- May 07, 2024
In C4 on the Tracking Grid sheet:
=TEXTJOIN(", ", TRUE, FILTER('Raw Data'!$A$2:$A$100, ('Raw Data'!$B$2:$B$100=C$3)*('Raw Data'!$C$2:$C$100=$B4), ""))
Adjust the ranges if the data on Raw Data extend below row 100.
Fill to the right and down.
Trumpetnut
May 08, 2024Copper Contributor
Wow. Thank you for this. I do have to say that it is not just a little bit, but light years ahead of any excel understanding I have, but I can see that it works in the file I have downloaded. The only issue I have is that when I add in any new raw data in the table it says that the formula has an unsupported function.
djclements
May 08, 2024Bronze Contributor
Trumpetnut That's unfortunate. The single-cell dynamic array formula will only work in Excel for MS365 or Excel for the web. I'm guessing you're using either Excel 2019 or 2021?
The same layout and functionality should still be achievable using HansVogelaar 's method with a few small adjustments. Try the newly attached file and see if it works in your version of Excel... Cheers!