<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div name="messageBodySection">
<div dir="auto">I’ve often asked in the google forum for sheets. Gotten lots of good help! </div>
</div>
<div name="messageSignatureSection"><br />
Annamarie
<div dir="auto"><br /></div>
</div>
<div name="messageReplySection">On Nov 26, 2024 at 11:04 AM -0500, Rob Laporte via Hidden-discuss <hidden-discuss@lists.hidden-tech.net>, wrote:<br />
<blockquote type="cite" style="border-left-color: grey; border-left-width: thin; border-left-style: solid; margin: 5px 5px;padding-left: 10px;">
<div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<div>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. </div>
<div><br /></div>
<div id="Zm-_Id_-Sgn" data-sigid="1535369000000073001" data-zbluepencil-ignore="true">
<div style="font-family: Verdana; font-size: 12px; line-height: normal; margin: 0px"><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif">Best Regards,<br /></span></span></div>
<div style="font-family: Verdana; font-size: 12px; line-height: normal; margin: 0px; min-height: 15px"><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif"><br /></span></span></div>
<div style="font-family: Verdana; font-size: 12px; line-height: normal; margin: 0px; color: rgb(170, 48, 37)"><b><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif">Rob Laporte</span></span></b><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif"><br /></span></span></div>
<div style="font-family: Verdana; font-size: 12px; line-height: normal; margin: 0px"><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif">CEO | R&D Manager</span><span class="font" style="font-family:verdana, sans-serif"><br /></span></span></div>
<div style="font-family: Verdana; font-size: 12px; line-height: normal; margin: 0px"><b><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif">DISC - Making Websites Make Money</span></span></b><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif"><br />
<a href="mailto:Rob@2disc.com" target="_blank">Rob@2disc.com</a>, <span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif">413-584-6500</span></span></span></span><br /></div>
<div style="font-family: Verdana; font-size: 12px; line-height: normal; margin: 0px"><span class="size" style="font-size:13px"><span class="font" style="font-family:verdana, sans-serif"><a target="_blank" href="https://www.2disc.com">www.2disc.com</a></span></span><span class="size" style="font-size:16px"><span class="font" style="font-family:arial, helvetica, sans-serif, sans-serif"></span></span><br /></div>
<div style="font-family: Verdana; font-size: 12px; line-height: normal"><span class="size" style="font-size:16px"><span class="font" style="font-family:arial, helvetica, sans-serif, sans-serif"></span></span><br /></div>
<div><b style="font-family: Verdana; font-size: 12px; line-height: normal"><span class="size" style="font-size:16px"><span class="font" style="font-family:arial, helvetica, sans-serif, sans-serif"><span class="colour" style="color:rgb(153, 0, 0)">NOTE:</span></span></span></b><span class="size" style="font-size:16px"><span class="font" style="font-family:arial, helvetica, sans-serif, sans-serif"><span class="colour" style="color:rgb(153, 0, 0)"> 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.</span></span></span><br /></div>
</div>
<div><br /></div>
<div class="zmail_extra_hr" style="border-top: 1px solid rgb(204, 204, 204); height: 0px; margin-top: 10px; margin-bottom: 10px; line-height: 0px;"><br /></div>
<div class="zmail_extra" data-zbluepencil-ignore="true">
<div><br /></div>
<div id="Zm-_Id_-Sgn1">---- On Mon, 25 Nov 2024 15:50:49 -0500 <b>Michael Muller via Hidden-discuss <hidden-discuss@lists.hidden-tech.net></b> wrote ---<br /></div>
<div><br /></div>
<blockquote id="blockquote_zmail" style="margin: 0px;">
<div>
<p><span class="font" style="font-family:Calibri">Hey all,</span><br /></p>
<p><span class="font" style="font-family:Calibri">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.<br /></span></p>
<p><span class="font" style="font-family:Calibri">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.</span><br /></p>
<p><span class="font" style="font-family:Calibri">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.<br /></span></p>
<p><span class="font" style="font-family:Calibri">Anyone has a minute and some expertise in this area?</span><br /></p>
<p><span class="font" style="font-family:Calibri">Thanks,</span><br /></p>
<p><span class="font" style="font-family:Calibri">Mik<br /></span></p>
<pre class="x_963775385moz-signature">--
Mik Muller, president
Montague WebWorks
20 River Street, Greenfield, MA
413-320-5336
<a target="_blank" href="http://MontagueWebWorks.com" class="x_963775385moz-txt-link-freetext">http://MontagueWebWorks.com</a>
Powered by ROCKETFUSION<br /></pre></div>
_______________________________________________<br />
Hidden-discuss mailing list - home page: http://www.hidden-tech.net<br />
Hidden-discuss@lists.hidden-tech.net<br />
<br />
You are receiving this because you are on the Hidden-Tech Discussion list.<br />
If you would like to change your list preferences, Go to the Members<br />
page on the Hidden Tech Web site.<br />
http://www.hidden-tech.net/members<br /></blockquote>
</div>
<div><br /></div>
</div>
<br />
_______________________________________________<br />
Hidden-discuss mailing list - home page: http://www.hidden-tech.net<br />
Hidden-discuss@lists.hidden-tech.net<br />
<br />
You are receiving this because you are on the Hidden-Tech Discussion list.<br />
If you would like to change your list preferences, Go to the Members<br />
page on the Hidden Tech Web site.<br />
http://www.hidden-tech.net/members<br /></blockquote>
</div>
</body>
</html>