Choose function?

%3CLINGO-SUB%20id%3D%22lingo-sub-1101233%22%20slang%3D%22en-US%22%3EChoose%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101233%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20stuck%20with%20something%20that%20I%20need%20to%20prepare%20for%20work.%20It%20is%20probably%20easy%20to%20fix%2C%20but%20I%20have%20not%20that%20much%20experience%20with%20Excel%20yet..%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%3A%20I%20have%20a%20large%20dataset%20(table)%20in%20tab%20number%201%20(Hunderds%20of%20rows%20and%20a%20few%20coloums%20with%20both%20quantitative%20and%20qualitative%20values).%20So%20for%20example%20the%20titles%2Fcolums%20of%20my%20table%20say%20'type'%20and%20classified%20the%20rows%20in%20a%20few%20specific%20types%20as%3A%20sold%20%2F%20bought%20%2F%20option%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20tab%20number%202%20I%20want%20to%20have%20the%20same%20list%20but%20then%20only%20the%20rows%20that%20match%20with%20one%20specific%20qualitative%20value%2C%20for%20example%20'sold'.%20So%2C%20the%20result%20would%20look%20the%20same%20as%20if%20I%20would%20copy%20the%20table%20from%20tab%20number%201%2C%20but%20then%20leave%20a%20permanently%20filter%20on%20'sold'%20for%20my%20list%20in%20tab%20number%202.%20I%20just%20don't%20know%20how%20to%20get%20that%20'permanently'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20a%20lot%2C%20and%20I%20think%20I%20should%20use%20CHOOSE%20and%20than%20combine%20this%20with%20a%20condition%3F%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20unfortunately%20I%20didn't%20succeed%20yet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20tips%20would%20be%20much%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1101233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1104805%22%20slang%3D%22en-US%22%3ERe%3A%20Choose%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1104805%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F513378%22%20target%3D%22_blank%22%3E%40Vivilc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20I%20understood%20your%20requirements%20in%20full%20but%20let's%20hope%20I%20did.%20Please%20look%20at%20attached%20file.%20Tab%20%22all%20data%22%20would%20be%20the%20big%20list%20with%20hunderes%20of%20rows%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%20%22filtered%22%20is%20the%20one%20where%20you%20filter%20(for%20example%20sold%2C%20bought%2C%20etc.)%20You%20could%20us%20the%20slicer%20(marked%20in%20yellow)%20to%20make%20the%20selections.%20Is%20that%20what%20you%20are%20looking%20for%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1108074%22%20slang%3D%22en-US%22%3ERe%3A%20Choose%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1108074%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply%20to%20my%20vague%20question%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20forgot%20to%20write%20that%20I%20wish%20to%20have%20it%20'dynamic'.%20So%2C%20that%20if%20I%20would%20add%20a%20new%20row%20in%20tab%201%2C%20it%20would%20than%20be%20automatically%20be%20added%20or%20not%20on%20tab%202%20as%20well%20(depending%20on%20the%20filter%20ofcourse).%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thought%20that%20I%20had%20to%20use%20a%20formula%20as%20Vlookup%20or%20CHOOSE%20if%2C%20but%20your%20suggestion%20with%20the%20slicer%20works%20well%20for%20my%20problem!%26nbsp%3B%3C%2FP%3E%3CP%3ECheers!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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) in tab number 1 (Hunderds of rows and a few coloums with both quantitative and qualitative values). So for example the titles/colums of my table say 'type' and classified the rows in a few specific types as: sold / bought / option etc. 

In tab number 2 I want to have the same list but then only the rows that match with one specific qualitative value, for example 'sold'. So, the result would look the same as if I would copy the table from tab number 1, but then leave a permanently filter on 'sold' for my list in tab number 2. I just don't know how to get that 'permanently'.

 

I have tried a lot, and I think I should use CHOOSE and than combine this with a condition? 

However, unfortunately I didn't succeed yet. 

 

Any tips would be much appreciated!

 

 

2 Replies

Hi there@Vivilc 

 

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?

 

 

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!