Forum

Hi Steve, What you're trying to do isn't totally clear and without your workbook again I can't see any code or the form. Why not just create a s...

You're welcome.

No worries 🙂

Hi Amel, Please see the attached workbook as a starting point. Once you've calculated your Mean and SD it's straight forward to calculate 3SD, 2SD...

Hi Amel, Try this = IF(N5="Alinity hq I (173)","Amel Al Faris", IF(N5="Alinity hq II (198)","Amel Al Faris", IF(N5="Sysmex 2500","Moneer"))) ...

Hi Damien, When you are attaching files to the forum you are attaching XLSX files which cannot have VBA code in them so each time we have to add th...

No worries.

Hi Bruce, Welcome to the forum, can I please ask you to review this I'm not really sure what you are asking. As Mynda already told you in emai...

Hi Damien, Can you please explain exactly what it is you are trying to do? I'm not clear if you are trying to colour in all countries at once, or ...

Hi Damien, If you can attach your workbook I can write something specific for you but without it I can only give you something generic like this us...

Hi David, We don't know how you intend to use the data so before you go writing VBA, why not use filters as Purfleet suggests? See attached. ...

Hi Declan, Create a PT = Create a PivotTable. If your dummy workbook can have a PivotTable with the same fields/structure-visualize-data as the re...

Hi David, You haven't said what the problem is. Are you receiving an error message? It works fine for me so I'm not sure what to say. Maybe ...

Hi Fahad, The first qs requires you to work out the average score for undergraduates and then look that value up. To work out the average score for...