MAXROW with multiple results

[Jp4Real]

Hi all,

Looking for input, I have data in which I look for the maximum SCORE of an item, but there could be a scenario where multiple items have the same max score,

Now I don't need to know which Item has the same score as the others, just that there is more than 1

I thought I could do a COUNT(MAXROW("Table","Score")) and get the info from there, but reading on maxrow confirms to me that it's going to return 1 random value if results from MAXROW contains more than 1 item

Any one of you has tackled this before?

thank

[Kirk_Masden]

I used "App Sheet Pro Assistant" (made by @LooToS ) to answer this question.  Here's the answer:
https://chat.openai.com/share/5c2e3d3f-a8de-4fa6-a732-21d5726f5514
For more about App Sheet Pro Assistant, see the following post:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Try-out-my-Custom-GPT-for-AppSheet-with-the-enti...

[Jp4Real]

hey ! sorry for the late reply but that tool is SEXY !! awesome, I'll try using it

thanks

[Kirk_Masden]

I've been using AppSheet for a while but I tend to forget how to do things.  So, for me, ChatGPT is quite useful.  But, while it can be super smart at times, it can be really stupid at times too -- kind of an idiot savant. 🙂