Forum Discussion
Select Where but Excel
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.
❤️
If you have Office 2021 or Microsoft 365, you can use the FILTER function
If you have Office 2021 or Microsoft 365, you can use the FILTER function
HansVogelaar I have googled and googled this and somehow never came across this SIMPLE solution. Thank you!
