Thursday, March 20, 2014

yogi_Pull Row By Row Date HomeTeam AwayTeam HomeGoal AwayGoal For Unique Set Of Scores

                                         Google Spreadsheet   Post  #1567
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-20-2014
post by marcfonteijn (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/qcGDd0vNsHU)
Combining Unique and Filter?
How can I use the result (2 column) of a UNIQUE function as the input for a FILTER function?

I'm using something like this:
=UNIQUE(D2:E16)

And now I have to manually enter the cells in multiple filter functions. Of course this won't work for long as my unique function will be returning different values. Show how can I make the function here below dynamic?
={FILTER(A2:E16;D2:D16=D19;E2:E16=E19);FILTER(A2:E16;D2:D16=D20;E2:E16=E20);FILTER(A2:E16;D2:D16=D21;E2:E16=E21)}

I've made an example sheet that has some sample data that I'm working on.
---

This function:
=FILTER(A2:C,MMULT((A2:A<TRANSPOSE(A2:A))*(B2:B=TRANSPOSE(B2:B)),SIGN(ROW(A2:A)))=0)
Described at https://productforums.google.com/forum/#!topicsearchin/docs/filter$20unique|sort:date|spell:true/docs/AbNGpZ5NqXI is almost what I'm looking for with the difference that I need to work on 3 column not 2... Is there a way to make the this function work with 3 columns?



--------------------------------------------------------------------------------------------------------------------------------



No comments:

Post a Comment