club pointscore

[rab31]

I have a number of scores earned by competitors at each round of an event. I wish to add Club Pointscores how can I get competitors score to also appear in the clubs coloum.

[AliGW]

Welcome to the forum.

In L5 copied across and down:

=IF(TRIM($D5)=TRIM(L$4),$K5,"")

[Zekeria]

Hello,

I hope this is what you wanted!

Regards,
Ziky

[Richard Buttrey]

Hi and welcome to the forum.

Your request is not clear. For these sorts of things we generally require you to manually add the results you expect along with a brief note (unless it's blindingly obvious) as to how you have calculated he results.

[AliGW]

@ Zekeria

Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

[Zekeria]

Thank you for guiding me! I am new here so didnt know the rules. I will try my best to explain my solutions form now on!

[rab31]

Welcome to the forum.

In L5 copied across and down:

=IF(TRIM($D5)=TRIM(L$4),$K5,"")

awesome that worked thanks

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.