Filter Function Help Please

[davidcox9]

Hello,

I have a filter function to return invoice numbers, however it is showing the same # multiple times. If there are two of the same number I only want to show it once, but I'm not sure how to change the formula. Here is what I have as the formula right now, and what it's returning.

The 'ACCRUAL CHECK LIST'!Criteria is just the company name, and $H$1 is just the month I'm working on.

=FILTER('DETAILS - Oracle Data'!G:G,('DETAILS - Oracle Data'!B:B='ACCRUAL CHECK LIST'!Criteria)*('DETAILS - Oracle Data'!S:S='ACCRUAL CHECK LIST'!$H$1),"")

Invoice #'s

9009577699

9009577699

9009578068

9009578068

 

[RobP]

try using "UNIQUE()" wrapped around it.

 

[davidcox9]

I've tried that several times I guess I was making it more complicated than I needed to that worked thank you!

 

[RobP]

Great, glad to have helped..
Rob