Sunday, May 7, 2017

yogi_Pull Row By Row GroupNos For Which Entries Are Greater Than 0

Google Spreadsheet   Post  #2159
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-07-2017
question by CAB05:
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?

No comments:

Post a Comment