Posts by BigDanMo

    Hi Carim,


    My apologies - the result should be all the individuals with results below the highest score for each section (3 for Q1, 4 for Q2 etc.).


    Normally there is no more than 1000 records per sheet.


    The second sheet is what I'd be looking for! (without duplicates if possible, as sometimes individuals appear twice for not getting full points on a section).


    Is it possible to create a VBA macro that does this?


    Thank you again for all of your help! :)

    Hi there,


    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! ^^


    D