[Hidden-tech] Looking for Google Sheets formula help

[Annamarie]

I’ve often asked in the google forum for sheets. Gotten lots of good help!

Annamarie

On Nov 26, 2024 at 11:04 AM -0500, Rob Laporte via Hidden-discuss <hidden-discuss at lists.hidden-tech.net>, wrote:
> 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
> Rob at 2disc.com, 413-584-6500
> 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
>
>
> _______________________________________________
> 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/20c29a6e/attachment.html>