Friday, August 4, 2017

yogi_Pull Value In Row 1 of Columns That Meets Criteria By Comparing Values In Specified Set of Columns

Google Spreadsheet   Post  #2214

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-04-2017
question by Benjamin Ohashi:
https://productforums.google.com/forum/#!topic/docs/h1h5xSvjWj0;context-place=mydiscussions

Formula that compares multiple columns?

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..). 

Is there any formula to make this possible?  



No comments:

Post a Comment