Forum Discussion

Vivilc's avatar
Vivilc
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
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 13, 2020

Hi thereVivilc 

 

I'm not sure I understood your requirements in full but let's hope I did. Please look at attached file. Tab "all data" would be the big list with hunderes of rows

 

Sheet "filtered" is the one where you filter (for example sold, bought, etc.) You could us the slicer (marked in yellow) to make the selections. Is that what you are looking for?

 

 

  • Vivilc's avatar
    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's avatar
      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.

Resources