Profile cover photo
Profile photo
Yogi Anand
867 followers
867 followers
About
Yogi's posts

Post has attachment

Post has attachment
yogi_Starting With Cell (row 6 and column of cell marked etctrfh) Compute Row By Row Sum Of Every Nth Column
Google Spreadsheet   Post  #2119 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficientbuild.com .   Feb-18-2017 question by Daxter2500 : https://productforums.google.com/forum/?utm_medium=email&utm_source=best...

Post has attachment

Post has attachment
yogi_Starting With Cell H5 Compute Row By Row Sum Of Every Nth Column In The Corresponding Row
Google Spreadsheet   Post  #2118 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficientbuild.com .   Feb-18-2017 question by Daxter2500 : https://productforums.google.com/forum/?utm_medium=email&utm_source=best...

Post has attachment

Post has attachment
yogi_In Rows C2:I And Down Pull Row By Row Values From Last Seven Columns Of The Corresponding Rows
Google Spreadsheet   Post  #2117 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficientbuild.com .   Feb-18-2017 question by GeoTechGuy : https://productforums.google.com/forum/?utm_medium=email&utm_source=best...

Post has attachment

Post has attachment
yogi_From Table B:I Of FoosBall Scores Compute Row By Row Loser (with a numeric score of less than 10)
Google Spreadsheet   Post  #2116 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficientbuild.com .   Feb-17-2017 question by Brian Bimschegler : https://productforums.google.com/forum/?utm_medium=email&utm_sour...

Post has attachment
Yogi Anand commented on a post on Blogger.
Hi +Max Schwarz :

in response to your comment
"How can I modify this and change the label for the 'count' column?"

change the formula to
=ARRAYFORMULA(query(if({1,1},trim(transpose(split(concatenate(substitute({D2:D;E2:E;F2:F},",",char(9))&char(9)),char(9))))),"select Col1,count(Col2) group by Col1 order by count(Col2) desc,Col1 label Col1 'Item',count(Col2) 'new name' "))

Post has attachment
Wait while more posts are being loaded