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

[@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]

Tolong jangan terlalu cepat. 😀 thank semoga manfaat.

[@user-fz5fh9su5l]

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]

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

[@qasimawan3569]

That’s really useful, thanks dude

[@enrikekasijas705]

Very cool

[@bronzejourney5784]

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

[@stevemin6842]

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

[@dhil_project]

Nice

[@usmanahmad7758]

Can we use Hstack function instead of Choose function?

[@persl8]

Is that work on excel 16? Or only on 365

[@ryankriller1931]

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

[@tranhuong7879]

thanks

[@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.

[@nagarajk969]

This option not coming in Excel 2016

[@iyomotono]

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 👍

[@scorpleeon]

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

[@hein0712]

How does it know “sharps” means knife

[@easy_sheets]

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

[@Rk-bh7ru]

Use Double filter formula instead of this.

[@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]

​@@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.