ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
How to CHOOSE columns when using the FILTER function in Excel!
ความคิดเห็น • 32
ต่อไป
เล่นอัตโนมัติ
Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)Leila Gharani
มุมมอง 713K
Excel FILTER Function + Trick to Rearrange Column OrderMyOnlineTrainingHub
มุมมอง 153K
เหตุผลที่ลาออกจากงาน #การ์ตูน #tamzen #แต้มเซน #shortvideoTAMZEN
มุมมอง 96K
ไฮไลท์เจลีก คอนซาโดเล่ ซัปโปโร เปิดบ้านถล่ม ซางัน โทสุ 5-3 | 16.08.24Siamsport
มุมมอง 186K
ออกพรรษาน้ำตาหล่น - แอน อรดี [OFFICIAL MV]หมอลำใจเกินร้อยofficial
มุมมอง 231K
LISA - NEW WOMAN feat. Rosalía (Official Music Video)LLOUD Official
มุมมอง 38M
5 Advanced DATA VALIDATION TRICKS in Excel (with Examples)The Excel Experience
มุมมอง 5K
🔥Combination of Vlookup & Sequence Function🔥Creative Excel
มุมมอง 14
URGENT!! Sound the Alarm!! ITS TIME TO GET RICH!! 🧨🎉🙏🏾 #investing #stocks #moneyKJ the Investor
มุมมอง 66
Excel Filter Function Across Multiple SheetsSheet Skunk
มุมมอง 6K
Garment Production TNA Template Tutorial in Excel | Streamline Your Workflow!GARMENT SOLUTIONS
มุมมอง 2.6K
Daily Organization Planner Tutorial| Expandable Weekly and Daily PlannerSheetIgnite
มุมมอง 1
How to use the brand new checkboxes in Excel! #microsoftambassadorEasy Sheets
มุมมอง 55K
Next level FILTER Function tricks | Excel Off The GridExcel Off The Grid
มุมมอง 17K
芙蕾雅居然出轨了?乔后悔了#shorts #Fairy#fairytales精灵少女
มุมมอง 823K
Live! ถ่ายทอดสดหวย ถ่ายทอดสดการออกรางวัลสลากกินแบ่งรัฐบาล งวดวันที่ 16 สิงหาคม 2567เรื่องเล่าข่าวร้อน
มุมมอง 701K
อดีตตำรวจเตะเณรปากแตก ข้อหาซุกเมียผม ลั่นเคลียร์มาให้จบจะเอายังไง l EP.1738 l 16 ส.ค.67โหนกระแส [Hone-Krasae] official
มุมมอง 1.5M
[TH] VALORANT Champions Seoul - Playoffs Day 5 - FNC vs SENVALORANT Esports Thailand
มุมมอง 134K
🔴LIVE เชียร์สด : อิปสวิช ทาวน์ พบ ลิเวอร์พูล | หงส์แดงบุกรังม้าขาว นัดเปิดฤดูกาลGOTJISIRI CH
มุมมอง 307K
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.
Tolong jangan terlalu cepat. 😀 thank semoga manfaat.
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.
You Excel at teaching Excel. ❤💯
I swear I have been looking for a solutiom for 3 days straight... sometimes I thank God the algorithm is listening
That’s really useful, thanks dude
Very cool
This guy woke up one day and went "Imma Excel".
Brah, good video but we need to keep replaying certain parts to see your data and results...
Nice
Can we use Hstack function instead of Choose function?
Is that work on excel 16? Or only on 365
Although this is meant for excel, is there a way to adapt this to google sheets?
thanks
Wouldn’t the choosecol function work better?
See pinned comment!
Can you use choosecols instead?
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.
This option not coming in Excel 2016
i dont have something like that "sharps"
Why not use a pivot table?
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.
@@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 👍
Filter function? I know not that of which you speak 😭 I gotta watch more videos and take classes at work
How does it know “sharps” means knife
It doesn't, Sharps is one of the options in the "Store" column
Use Double filter formula instead of this.
Bad sample ... could not even see column A
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.
@@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.
There's literally a much easier CHOOSECOLS function that he straight up ignored
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.