How to CHOOSE columns when using the FILTER function in Excel!

No video

How to CHOOSE columns when using the FILTER function in Excel!

Рет қаралды 149,399

Easy Sheets

Жыл бұрын

Пікірлер: 32

@easy_sheets Жыл бұрын

Since i keep getting asked why i didn't use CHOOSECOLS instead, i'll make it a pinned comment: CHOOSECOLS uses column index numbers, were as CHOOSE uses cell references. If columns were inserted or deleted then any function using index numbers will break. Using CHOOSE insures that the function never breaks.

@dhil_project 11 ай бұрын

Tolong jangan terlalu cepat. 😀 thank semoga manfaat.

@user-fz5fh9su5l 8 ай бұрын

Great use for Choose, but honestly, using FILTER(FILTER(B2:D27, A2:A27="sharps"),{0,1,1}) looks cleaner, more dynamic and easier to change if needed.

@A-Migos Жыл бұрын

You Excel at teaching Excel. ❤💯

@shewana4371 9 ай бұрын

I swear I have been looking for a solutiom for 3 days straight... sometimes I thank God the algorithm is listening

@qasimawan3569 11 ай бұрын

That’s really useful, thanks dude

@dhil_project 11 ай бұрын

Nice

@enrikekasijas705 Жыл бұрын

Very cool

@bronzejourney5784 8 ай бұрын

This guy woke up one day and went "Imma Excel".

@tranhuong7879 Жыл бұрын

thanks

@stevemin6842 2 ай бұрын

Brah, good video but we need to keep replaying certain parts to see your data and results...

@persl8 11 ай бұрын

Is that work on excel 16? Or only on 365

@usmanahmad7758 2 ай бұрын

Can we use Hstack function instead of Choose function?

@ryankriller1931 Жыл бұрын

Although this is meant for excel, is there a way to adapt this to google sheets?

@sideshowbobby71 Жыл бұрын

Wouldn’t the choosecol function work better?

@easy_sheets Жыл бұрын

See pinned comment!

@ajscx Жыл бұрын

Can you use choosecols instead?

@easy_sheets Жыл бұрын

You can but it's more fragile. The CHOOSE function is objectively better because it uses a range instead of a column index. Functions that use column indexes are broken when a column is inserted or deleted.

@scorpleeon Жыл бұрын

Filter function? I know not that of which you speak 😭 I gotta watch more videos and take classes at work

@nagarajk969 9 ай бұрын

This option not coming in Excel 2016

@iyomotono 4 ай бұрын

i dont have something like that "sharps"

@bobbarker142 Жыл бұрын

Why not use a pivot table?

@easy_sheets Жыл бұрын

There's a least 1000 different ways to achieve the same result in Excel. Different methods have different use cases. I'm teaching all the methods because having options means you can choose the right way depending on your situation.

@bobbarker142 Жыл бұрын

@@easy_sheets gotcha. Would be helpful if you’d explain a few popular use cases for each method and why one is more effective than the other in certain scenarios. I like the content 👍

@Rk-bh7ru 10 ай бұрын

Use Double filter formula instead of this.

@hein0712 Жыл бұрын

How does it know “sharps” means knife

@easy_sheets Жыл бұрын

It doesn't, Sharps is one of the options in the "Store" column

@michaeltmnguyen Жыл бұрын

Bad sample ... could not even see column A

@easy_sheets Жыл бұрын

As far as the point of the video goes column A doesn't matter much, i just use it to build the filter condition. But I probably should've edited it to show everything. To fill you in, column A is "Store" and the value "Sharps" is a value in that column.

@maykee_kun 11 ай бұрын

@@easy_sheetssir i think column A mattered. The value in column A was part of your formula. I was confused when you used sharps as conditions but it was not shown in the vid. So it mattered.

@gregsdoodles4547 Жыл бұрын

There's literally a much easier CHOOSECOLS function that he straight up ignored

@easy_sheets Жыл бұрын

No i didn't ignore it, I chose to use CHOOSE because it's better. CHOOSE uses cell references, were as CHOOSECOLS uses a column index number. Using an index will break the function when a column is inserted or deleted, but my formula will never break.