Problem with Unique function after trasnfering from Excel 2019 to Google Sheets (online)

[nahaku]

I have a file with attendance and I am using =UNIQUE(FILTER('Activity Tracker'!D2:D86,'Activity Tracker'!D2:D86<>""))
To get list of people from table. The table has only unique values but is divided by many empty cells or cells what has some another value. They are in same Column D.
When I use the function above and transfer it to Google Sheets it will give me this
=ARRAY_CONSTRAIN(ARRAYFORMULA(UNIQUE(_xlws.FILTER('Activity Tracker'!D2:D86,'Activity Tracker'!D2:D86<>""))), 43, 1)
is there some fix or other function how to make it work in Google Sheets? Thank you.

 

[nahaku]

Ok it looks like it does not understand the Filter function...Unique Function works. I would like to ignore empty cells... Any idea how to do it?

 

[nahaku]

I found if i use this formula in Google Sheets
=unique(query('Activity Tracker'!D2:D86,"select D where D<>''"))
It will works, but when I download that file it will replace it with
=IFERROR(@__xludf.DUMMYFUNCTION("unique(query('Activity Tracker'!D2:D86,""select D where D<>''""))"),"GBS0179")
So if I do any change in downloaded file it will not update the list...
Can you advice any universal formula what should work in Excel and in Google SheetS? thank you