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?

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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#row zero
#big data management in spreadsheets
#financial modeling with spreadsheets
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#google sheets
#cloud-based spreadsheet applications
#AI-native spreadsheets
#predictive analytics in spreadsheets
#darts league
#excel
#table
#checkout
#highest score