SOLVED

Select Where but Excel

Copper Contributor

Hello Friends,

 

I would like to return values in one column based on certain conditions in a different column (but on a separate sheet).

 

Does anyone know the best way to do this? I basically want to create a new table from another table with filtered values but make it refreshable.

 

Help? I might be overthinking this.

 

<3

 

2 Replies
best response confirmed by terraficke (Copper Contributor)
Solution

@terraficke 

If you have Office 2021 or Microsoft 365, you can use the FILTER function 

@Hans Vogelaar I have googled and googled this and somehow never came across this SIMPLE solution. Thank you!

1 best response

Accepted Solutions
best response confirmed by terraficke (Copper Contributor)
Solution

@terraficke 

If you have Office 2021 or Microsoft 365, you can use the FILTER function 

View solution in original post