Looking for a function to filter but only want to return back unique visible cells

[kac1125]

I have the Data I want to filter in Sheet1 column A So I want to populate all unique values that are visible in column A, I have a helper column X where 1 = visible. This is the formula I have, however it is populating more than just the visible cells. =UNIQUE(FILTER(Sheet1!A:A,Sheet1!X:X=1,"")). Any Ideas on how to display just the unique results from column A on the visible rows?

Thanks!

 

[kac1125]

Figured it out! Thanks!