Sunday, January 1, 2017

yogi_Compute Row Number Of Nth Negative Number Up From last Occupied Cell In Column A

›
Google Spreadsheet   Post  #2103 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficient...

yogi_Convert Fraction To Percent

›
Google Spreadsheet   Post  #2102 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficient...

yogi_Conditionally Format In Column B Top 3 Unique or Non-Unique Entries as noted

›
Google Spreadsheet   Post  #2101 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficient...
Tuesday, December 27, 2016

yogi_Formulate Query For Numeric Stats When Using Fields With Mixed NUMERIC and TEXT (or blank) Cells

›
Google Spreadsheet   Post  #2100 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficient...

yogi_Array Formula For Splitting Row By Row Entries In Column A Of Sheet 'T1 Cores'

›
Google Spreadsheet   Post  #2099 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficient...
Sunday, December 25, 2016

yogi_WorkAround For An ArrayFormula Application Where Normally SUMIFs Function Would be Used

›
Google Spreadsheet   Post  #2098 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficient...
Thursday, December 22, 2016

yogi_Condionallty Format Rows Where Emails Are The Same As Those in Tab Named 'Received'

›
Google Spreadsheet   Post  #2097 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficient...