I have a formula: =TEXTJOIN(",",TRUE,IF((Q:Q<>"")*(Q:Q<3),B:B,""))
Where: B:B is a column of people's names and Q:Q is a column for the results for an individual in a test.
The formula identifies which people have scored less than 3 marks in a section (column Q:Q).
I would like to be able to enter this formula into VBA (I am a beginner!) and am having some issues with examples I have found online. I would then like the formula to work for other columns (other test sections), if possible - so that individuals who are missing points can be identified.
Any help would be greatly appreciated!