Thursday, May 11, 2017
yogi_Pull Row By Row GroupNo For Which Entry in That Row Is The Largest Entry In That Row
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-08-2017
question by Hồ Quang Hướng:https://productforums.google.com/forum/#!topic/docs/UFZB8NZBMAE;context-place=forum/docs
SUMIFS providing correct values only when I delete&paste the same value
I have used an index/match/max filter to identify column headers of cells with a value greater than zero in a given range. This works fine when there is only one such cell in a range. But what if there are multiple cells with a value greater than zero in a range? Is there a formula I can use to identify all column headers for all cells with values greater than zero in a given range?