[Hidden-tech] Looking for Google Sheets formula help

[Rob Laporte]

I have found that asking an LLM like ChatGPT for Sheet/Excel formulas works quickly. Only the most complex, recursive calculations have required my asking more than once. 


Best Regards,



Rob Laporte

CEO  |  R&D Manager

DISC - Making Websites Make Money
mailto:Rob at 2disc.com, 413-584-6500

https://www.2disc.com



NOTE: Emails can be blocked by spam filters throughout the web. If you don’t get a reply within an expected span of time, please call.








---- On Mon, 25 Nov 2024 15:50:49 -0500 Michael Muller via Hidden-discuss <hidden-discuss at lists.hidden-tech.net> wrote ---



Hey all,

I have a multi-tab Google Sheet that keeps
        stats on players in a game I'm helping manage. Looking to do
        some intra-sheet math to create an index of the players.

Essentially, TAB1, TAB2, TAB3 all have
        player names in a left column, and a score in the next column
        over that need to be combined, and posted to a matching player
        field in TAB4.

I already know how to do things like
        this:    =COUNTIF(Guild!A1:A82, "21")    but I need to grab one
        field from three tabs, based on matching player names in all
        four tabs.

Anyone has a minute and some expertise in
        this area?

Thanks,

Mik

-- 
Mik Muller, president
Montague WebWorks
20 River Street, Greenfield, MA
413-320-5336
http://MontagueWebWorks.com
Powered by ROCKETFUSION


_______________________________________________
Hidden-discuss mailing list - home page: http://www.hidden-tech.net 
Hidden-discuss at lists.hidden-tech.net 
 
You are receiving this because you are on the Hidden-Tech Discussion list. 
If you would like to change your list preferences, Go to the Members 
page on the Hidden Tech Web site. 
http://www.hidden-tech.net/members
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20241126/ac58dbcf/attachment.html>