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   Mar-20-2014
post by marcfonteijn (!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:

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?

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

This function:
Described at!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?