2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

possible fix for darts league table in excel?

Our take

Are you struggling to get your darts league table in Excel to accurately reflect the highest checkout scores? If your setup involves multiple sheets for data entry, calculations, and final standings, it’s frustrating when values don’t populate as expected. The good news is that with the right formula, you can automate the process of tracking each player’s highest checkout, ensuring your leaderboard is always up to date.

Hello,

i am sorry if something is not explained properly, i am not very experienced in excel.

I made excel table for local darts league via chat gpt in order to keep track of stats and league standings of my local league but the only thing GPT has issues with is to make maximum checkout number showing in final sheet based on below. it uses 3 sheets 1 for me writing the data, 2nd for calculations and 3rd to show the table and keep the leaderboard clean.

what i have issue with is that on below screenshot, in row L, you write highest checkout for given player of given round, for instance 120. if the player scores higher, i will write it in the L row in the next round and it should determine the highest number and show it later in the final table as highest checkout (highest number from the player and given row)

as of now, the calculation (tabuľka_Data) which takes data from Kola_data shows the M column (which should show the highest score of the player) is empty.. therefore in the final table (Tabuľka) its also empty..

any way on what should i write there to make it work? if any other explanation necessary, please let me know. i even described to it what version and language of excel im using in order to avoid mistakes but so far after 15 attempts no fix solved.

if i manualy write it into Tabulka_Data in row M, it updates into final "Tabulka" nicely so the issue has to be between kola_Data and Tabulka_Data

for extra clarification, i will add upto 30-40 players each round to Kola_data and it should calculate it in tabulka_data to show in final Tabulka

HERE

thank you

submitted by /u/mayhemoGG
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article