Need help in creating formula from List

[maya2ph]

Hi guys,

Badly need your help in creating a formula or function, please see details in the attached file.

Thank you very much.

Sample.xlsx

Cheers,

Ronald

[FDibbins]

Your description is not very clear (for me, anyway). Can you give a few sample answers, and explain how you got them?

[azumi]

Not sure but try this, using array formula

[maya2ph]

Not sure but try this, using array formula

Thanks Azumi, you`ve saved me.

Cheers

[maya2ph]

Not sure but try this, using array formula

Hi Azumi,

Need your help again on this,

I encounter some problem if the participant is lesser than the given value.

Hoping to hear from you soon.

Thanks

[azumi]

Can you post another workbook for the problem? Im not clear without seeing your excel file.....

[maya2ph]

Not sure but try this, using array formula

Can you post another workbook for the problem? Im not clear without seeing your excel file.....

Since my net is very slow in with regards to the attachment I quoted the previous excel, I tried to lessen the participants and the result is zero or N/A when the given value is more than the participants.

Hope this helps.

Thanks

[azumi]

Ok then I try a little change to the formula, try to remove participants.... or add more (max 20 rows), you just extend the ranges as you need

[maya2ph]

Ok then I try a little change to the formula, try to remove participants.... or add more (max 20 rows), you just extend the ranges as you need

I try to remove participants f - I, I got a blank result in the assigned column.

Thanks