VERY GRATEFUL SIR, EXACTLY WHAT I NEED

Good Job 😊Excellent Video Thanks Again 😊

Even though I save it But it is not showing saved file in macro 😮

Lambda function well explained 🎉

Me watching the video in June 2024

How to remove this error for multiple different column's data i.e. non consecutive/continuous columns?Right now you are doing it only for 1 column.

Really great, thank you for sharing

Just saved my bacon

Thanks Sir for this video ❤

thank u very much you are teaching very well if it is possible you can teach us other softwares like R and stata

Your tutorial was brilliant, but I wanted to ask if it is possible to have a checkbox drop down list as you have sort of done and check each box like you do when you want to filter the data, if that makes sense?

This is great! I forgot the password of a sheet the other day and had to recreate it 🤦‍♀ is there a way to unprotect a workbook like that too?

You're a genius❤

dame, these formula just so smart and awesome. and super useful. you are rock Thanks so much

Magic, epic and unbelievable! right at the finger tip! I have seen cumbersome and convult combination of functions just to retrieve multiple records. The power of Excel is unmatched

I have still not received this new checkbox version in my Office 365 yet. Please guide me how to get it

From where can we practice excel? Like are there any exercises that we can do? Any websites or material?

You are a GENIUS! So simple--you saved me!

Awesome sir

You posted this 9 years ago and i've just discovered this today and it's STILL useful, so thank you, you're awesome!🙏

Hey Sumit, I am using 2016 version and unselecting Banded rows is causing no change to the table. Kindly help what am I doing wrong?

Welldone

Why doesn't it work for me? Is it because my data is not in English?

I am watching this in 2024, I am about to start my MBA journey from an IIM, and I am a bit weak in this laptop work, I watched your past 5 videos and now I am confident that after finishing the whole course, I am ready to work on excel. thank you so much Sumit Bhaiyaa. lots of love.

Good Job! Thank you for this.

If anyone reading this comment I need some advice,first how should in practice the things that I've learned from the video?should I watch same video for more than once for better understanding?and i think I should make notes of the stuffs to get easy access if I forget something so how should I make the notes?

Thanksss!😊

Really useful number formatting video. Thanks Paul

all i can see is workbook [5]DocumentSummary and [5]Summary information the file is on 2003 I think and I'm using 2013 and 2007 but I cant see the file it self

Thanks @trumpexcel for the Video. In the last example, if I needed just the incremental columns (retain the old and add the new) from Spotify results, what will be the steps? Thanks in advance.

I do it as shown in the video, but when I open it, the files that are there like sheet1, sheet2, sheet3 are not displayed

I didn't get why people say this are feature at 2030 2013 can someone explain

Thanks !!!

What about the fourth option of using conditional formatting? You can use the second method as a conditional format. This way, even sorting will not mess up your rows. Adding a row above it will make you have to chance isodd formula into iseven though… Anyways, thank you for the video!

It is amazing, thanks

Thank you so much!........... you 've covered huge information in just 20 minutes vedio.

Life changing...thank you!

Oh man you are fantastic. Between ChatGPT and other youtube videos I couldn't resolve until I found yours. THANK YOU!!!!!

Sir, thanks a lot for the detailed video. Till now I have used vlookup and index match for analysing data. Now will practice xlookup as explained in the video and improve my skills in excel.

great stuff mate ..

thank you so much for the detailed explanation of how the formula work. one question please, what if the date list is on horizontal side not vertical on column? how to conditional formatting that case?? the formula doesnt work in this case

Great video! Got right to the point and made it easy!!!

use the f4 and freeze the column only then we can copy-paste easily without changing the reference cell

Didnt know that excel can get complex! How can I enhance logic building skills?

Have just started learning excel for my upcoming MBA course . With this just one introductory video , I'm impressed with the presentation and excellent explanation skill of yours . You're really a saver for excel naives like me . Thank you ! Looking forward to this playlist .

Pl also show how to unprotect a protected MS word doc

Thank you Sumit for amazing comparison !!

Thanks for You's video!👍👍👍

These is make my work done.