Filter Values

[bertal34]

Need help with something easy but I can't seem to come up with elegant solution.  I attached a file with input and output I am looking for.  Basically trying to take the 3 most recent dates from data in INPUT (jul/aug/sep) and filter so that each Num (column B) must contain the 3 dates.  In my example, only Num values 1 and 5 should come through and 2,3,4 should be left out.  

Thanks in advance!

[JamesCharnley · Accepted solution]

Hi @bertal34,

I get the feeling this is one of my solutions that somebody can do more elegantly, but this should dynamically take those max 3 dates by Sampling, and finding instances where all three are contained by the numbers using the Summarize and Join tools.

[DavidSkaife]

Hi @bertal34 

Here is one way of doing it; you could exchange the 'IN' clause for the test column to be whichever month(s) you required, and the filter tool value accordingly.

[binuacs]

@bertal34 One way of doing this

[bertal34]

Thank you @JamesCharnley this works perfectly!!