Видео

how to do the same thing in mac? because this option is not showing on my mac

Very good examples!

Awesome..Thanks

can you share the link for the chart video mentioned at the end of video?

Well explained

Tq

Thank you so much!!

The best explanation about expand function ever. Thank you

This absolutely worth watching n learning new things in excel. I watched your couple of videos and learnt new things. Great JOB. I am you fan now.

This is first ever instance where I learnt something new, Thank you.

Really I liked your videos... Thanks for your time to post this..❤

Can we do this in PowerPoint?

Hi. I have a query: When I Convert file excel (From other sources), Table import wizard noticed that "0 Rows transferred". How can I fix it?. Although I checked my file again, and it actives nomarlly (it have 422 rows)

Nice. Please give the files

Thanks a lot sir 🙏

Hi Sir, Thank You for sharing a very interesting video on EXPAND 🙏🏾 Sir, what if the Products are: Belt Goggles Camera The final Product list should have the items in the same order (Belt, Goggles, Camera). The solution in the video will sort the item in A-Z order. Please suggest a solution. Thank You!

So far best video on these three pivot table topics!

Very good info! Thanks for sharing!

very helpful thanks!

no file for down load

Thanks a Lot!

INCREDIBLY Helpful!

thank you man

Great very helpful

clear instruction, thank you, so basically excel doesn't have bi-directional, mirror chart or wtf it is

Nice one.. Thanks a lot

But what if I want this letter on my company letterhead and also download this as a pdf for all these employees and use mail merge to send this?

Hi! what if i wish to combine multiple workbooks with the exactly sale headers? Please advise

❤😂

Great 👍🏼. Is there a way to apply the same concept and eliminate FRIDAYS from days between tow dated ?!

Superb!! waiting more the practical video like this

Great straightforward video, thanks!

Thanks Teacher

When I select 1st series, instead of highlighting a column, it highlights the entire row including a, b, c, d, e and f

You can achieve the same result by using a very short Syntax as below and then if needed, convert that into a lambda function with 4 input parameters as defined below the formula =INDEX(FILTER($B$3:$B$16,$A$3:$A$16=D3),E3) $B$3:$B$16 is the item names; in your case--> fruit names $A$3:$A$16 is the dates D3 is the individual item you want to evaluate E3 is the Nth value you wish to obtain In order to avoid errors on selection of the Nth value you can use the formula =SEQUENCE(COUNTIF($A$3:$A$16,D3)) and reference the above to a Drop Down list Once done, user can only select the numbers from the drop down

Can we get sequence of quarter date between two input dates? i.e., If I put 15 Jan. 2024 and 15 Dec. 2024 then it suppose to display 15 Jan. 2024, 15 Mar. 2024, 15 June, 2024, 15 Sep. 2024 and 15 Dec. 2024. Thanks in advance

Worked perfect! Thanks man

Thanks a lot for the video. I have made similar output with much more work the last many years. Now I have just to figure out how to expand with 3 or 4 tables. If anybody have an Expand formula ready using 3 or 4 tables, I will very much appreciate to see it.

Your Excel tutorials are fantastic, and I encourage you to keep up the excellent work! Your expertise and engaging teaching style make complex topics understandable. The practical insights you provide are invaluable. I look forward to more of your content, as it continues to be a tremendous asset for learners. Thank you for your dedication! 👏🚀

Your professional-level Excel tutorials are exceptional! Your expertise in breaking down complex features, paired with real-world applications, has significantly enhanced my skills. The commitment to high production standards amplifies the learning experience. Thank you for being a valuable resource for advanced Excel knowledge - your contributions are truly appreciated. 👏🚀

I feel there is a problem with the horizontal axis labeling. center should be 0 and then scaling should run both ways.

😁 Thanks for that solution concerning Pivot Tables that I'm looking for since long time...

Hello Sir, your videos are very helpful, do you provide personal trainings or can you provide practise files of all the videos?

Excellent practical examples- thank you! I have found myself using unique a lot & would not have thought of your solutions.

Great

Great video! Here is an easier to use formula to accomplish the job: =TOCOL(Table1[Product]&EXPAND("",,ROWS(Table2[month]),""))

awesome. i was looking for it this morning and found out at afternoon without looking for it.

thank you, does this apply to text fields as well?

kindly do share the excel sheet

I love you dude, thank you so much!