Video

its work for xlsx file

This was good working info. on the subject. Thanks 👍

Awesome trick

useful👍🏻

Some advanced stuff over conditional formatting is helpful for visualizing the data with ease. Thank you.

Helpful, and those symbols can make a clear pov of the data.

Had doubts about some custom formats. Now it's clear. Thank you, Admin

Hey Sumit the work that you do is pretty Great ❤ Kudos to you 🎉

A day before, I learned about DB creation, and this one is useful. Thank you, Sir.

this very usefull! i can rename 3 folders each had more than 300 files less than 30 minutes! THANKYOU VERY MUCHHH

reference file not opening

I've been looking for this solution for months! This goes in the toolbox. Many thanks for posting.

Sumitji, May I request you once again to please upload a video usingpower query method to remove duplicate from single cell.

Hello Sir, I need your help. I want a formula that if • if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated • If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated • if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated Please Reply Sir

Thank you Sumit for your efforts....

Great demo! FYI, you can also use the SORT function to add that layer.

Very useful

Another excellent video. I've been using Excel since 1990, and never encountered some of the things you covered. Particularly useful are the tips on wildcard searches, format searches, and merged-cell searches. Thank you!

Maine 5 Cell ka ek col. Me number data liya or is range ko "l" nam diya aise hi maine ek or range "b" banaya ab mai 3rd col ke first row me 2(l+b) formula calculate krna chahta hu but l range ka 1st row or b range ka bhi 1st row ka data hi is formula me use ho or aise hi next row k liye ho ise step by step excel me kaise karenge

The excel has decreed on my computer that this will work when I set it up in a new file and will not work after a while. Such is it's desire. So I will abide to it. I set it up, it works, I save the file as xlsm. close, re-open. No longer works!! What in the spaghetti code Microsoft!?!?!?!?!

Hi can you show me or create a shortcut macro for excel file.. as.xlsm If I wanted to delete particular columns every day instead of selecting individually.

Very nice video thank u very much

Thank you 😊

Amazing ❤

Great brother...your videos are being useful for me in 2024... Just wanted to learn some analytical skills and started with excel and fortunately found you... Thanks brother...♥️

Really Informative Thanks

My God! No words to express how great this video is going to save me

Excellent. I have become fan of you❤

Thanks

Thanks ❤

If I want to do vice versa of last trick or function? Then??

0.037

Last topic was something unknown and really useful

For me I need to execute the different ones when comparing two columns when they are matched partially (ex:-" apple Inc" is in column A and "apple" in Column D here the difference is " Inc " The difference Inc I need to find ) please help me on this sir

Sometimes hard to follow because you're terribly fast but very helpful. Thanks.

Sir can you give some exercises to do for particilar lessons that you teach in this course by which student can practise this for perfection in that commands that you teach . Sir plzz can you help me by doing this 🙏

06:34 why suddenly typed my name

Please can you advise what the formula would be if I wanted a range of cells to be looked at and if they contain a word, then the row colour is changed is that possible please, thank you

You are the TOP G of Excel

Thank you for sharing such wonderful explanation of each context of excel ❤

czcams.com/video/RClEHP_92pg/video.htmlsi=2YLs4p2QUhhbo3FE

czcams.com/video/RClEHP_92pg/video.htmlsi=2YLs4p2QUhhbo3FE

Super useful... Thank you so much.. keep educating us

Thanks ❤️

Great tool. I modified the conditional formatting to do two things. The first was to show the normal fill formatting of the highlighted cell. It makes it a bullseye without any changes. I use fill on certain cells to mean different things. This lets me see and change that without confusion from conditional formatting. The second part was I set cell A1 as a flag to turn it on or off. It's on if cell A1 = 1, off for any other value. It looks like this: =AND($A$1=1,OR(CELL("col")=COLUMN(),CELL("row")=ROW()),NOT(AND(CELL("col")=COLUMN(),CELL("row")=ROW())))

ALT PAGE UP IS NOT WORKING BOSS

Thank you. This really helped me to meet my deadline.

Tricks, Loved it ❤, Thanks!!!

Can you please upload your file again since I just can't download it? It blinks and then it does nothing. Thanks

Good job