Forum Discussion
AngieHollowell
Jul 11, 2023Copper Contributor
Filter function?
Hi All, I'm having difficulty updating a formula transferring a spreadsheet from Google Sheets to Excel (Office 365 web version). I was not the one to originally set up the Google sheet, but the ori...
OliverScheurich
Jul 11, 2023Gold Contributor
In Excel with a dynamic table you can try the FILTER function like this
=FILTER(Tabelle1[Prize];Tabelle1[Prize]<>"")
where Tabelle1 refers to the table name and [Prize] refers to the column name.
Without a dynamic table you can reference the ranges with the FILTER function like this:
=FILTER(SalespersonName!A2:Y2000,SalespersonName!A2:A2000<>"")