<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><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></body></html>