Forum Discussion

Copper Contributor

Jan 10, 2020

Choose function?

Hi all, I am stuck with something that I need to prepare for work. It is probably easy to fix, but I have not that much experience with Excel yet.. My problem: I have a large dataset (table)...

excel

Formulas and Functions

Vivilc

Copper Contributor

Jan 14, 2020

Hi PascalKTeam,

Thanks for your reply to my vague question 😉

I forgot to write that I wish to have it 'dynamic'. So, that if I would add a new row in tab 1, it would than be automatically be added or not on tab 2 as well (depending on the filter ofcourse).

I thought that I had to use a formula as Vlookup or CHOOSE if, but your suggestion with the slicer works well for my problem!

Cheers!

SamB513

Copper Contributor

Jun 01, 2022

Hi Vivilc,

What you're interested in is the Excel Filter() function:
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
This will return your dataset from the other sheet and filter it on the condition programmed in.

You could even get really clever and set the condition to a drop down, created from the column in the other sheet and then you could switch between sold and bought etc..

[edit]

Apologies, new here, and didn't realise the "related" post thrown at me was two years old.