Posts by BigDanMo

Hi Carim,

I will have a look tonight and get back to you!

Thank you again

Is it possible to add this formula to VBA with worksheet.function or Range("").FormulaArray?

Apologies if this is a stupid question!

DD

Hi Carim,

Now you've got me!

What does that involve, please?

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 Carim,

I have attached an example.

My formula can be found in cell AA1 for reference.

I've created bogus examples for DP reasons.

Thank you!

D

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