Friday, August 4, 2017
yogi_Pull Value In Row 1 of Columns That Meets Criteria By Comparing Values In Specified Set of Columns
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug-04-2017
Below is screenshot of my google sheets that I am referring to. My goal is to have the last column (top performer) display whatever column has the highest number for that respected row. For instance, the first cell under top performer should display "Google AdWords" as it had the highest number for that day. This formula of course would only be comparing the columns with a source name in it (google adwords, bing, craigslist, ect..).