Thank you so much Sumit. =if(isblank formula is great, you always make our life easy,

@trumpexcel

Жыл бұрын

Glad you found the video useful 😀

very helpful. Thanks

I AM SIMPLY LOVING YOUR VIDEOS. SOOOOO HELPFUL. THANKS TONS

You just made my life so much easier I have googled how to do this so many times and kept getting different answers that were right

Absolutely great video!!! Thank you so much!!!

Thank you.

great! finally found what I was looking for! Very good and clear English!!

@trumpexcel

3 жыл бұрын

Glad you found it useful

THANK YOU SO MUCH

Thankyou for this tutorial very helpful

I'm glad to come across this video. It was indeed helpful. Thank you so much.

Excellent job. Thank you

I appreciate this soooo much. THANK YOU!!!

SUPER, LOTS OF INFORMATION IN SINGLE VIDEO...

Your videos always amazing, especially custom formating clever tips, found it very useful, great job

Thank you so much I was really stuck literally. You have been very helpful

Thanks for this tutorial.

thank you sir,you are very helpful with your videos.

thank you. you are doing great work.

Thank You very much Sir... Your methods helped me a lot.

Thanks, been a long time did not use numbering in excel

Very good and useful tutorial

Thanks, it was useful.

Very nice tutural clear n easy way to understand

awesome tips!

Thank you!

Thanks yo. Very helpful, auto subscribe.

Great findings

Nice sir.Thanks.

Really amazing trick

thanks, really helpfull.

🙏 beautiful information sir ☺️

thanks you so much

Thank you

very good !

THANK YOU! I've been looking for an answer to my issue for 3.5 years. I have one special note: I'm numbering a ROSTER that has the party's LAST NAME in Column B and FIRST NAME in Column C. In a number of instances, there are two members of that party but we do NOT repeat the LAST NAME in Column B for aesthetic reason. By inserting a "space" in Column B, the system "thinks" there is text there and assigns a number for the 2nd member of that family. THANK YOU so much as I've been manually numbering for years.

Thank you very 5

Hello Sir, do you have any video only for all the formulas. Please upload that too, I could not find it. Very nice and easy way of teaching. Congratulations

usefull, ThankU

Nice sir

Thank you. Is there a way you can type the number of rows then stop the rows at that inputed number. EG on H1 type 5 then rows end at A5?

Hello , what i have some rows highlighted in specific color and i want to give each color a serial number (for example the white cells will have their own and the yellow ones will be counting aside ) ?

You mister just saved my ass with this video! :D

Thank you. But in Subtotal when you filtered greater than 50, at the bottom of the tabulation it selected less than 50 valued rows too. How do we avoid it? That is where I am stuck and I noticed it is there for you too.

After a blank space in a row, how do I start the count from number 1. Can you please show some method. Your video is informative. Thank you.

Thanks! How to increase rows with a dot after the number by pulling the handle?

Shortcut for creating table Press CTRL+T

OMG 15 minutes for a simple task

In count formula how did you lock that B2?

@pranavmanohaur391

Жыл бұрын

EXACTLY

Thank you but in my ms excel + sign does not appear in fill handle and I am unable to use drag function of the pointer.What could be the problem

Hi.. can you tell how to use macro in excel..

Sir but missing complex numbering system like " EXP/001/18-19" special for invoice numbering........ Please solve.......

Hey I added extra rows and given sno, but it doesn't showing nos at all wt to do?

Error in Subtotal function If we use filter by keeping any condition if condition true or false unnecessary it is showing the last row.

@excelkingtamil571

5 жыл бұрын

I am facing same problem

Hii .. long time no see

What if, in column A I have data series of 1,2,3,4,5 and next column I need to generate 11,22,33,44,55 without multiply 11 and use paste special method. Automated method?? Thank you.

@ksdnsdkumar1375

4 жыл бұрын

please post your doubt at superuser.com

when making graphs, my computer doesnt bring graphs on pressing Alt+f1.kindly help

Sir, how can we give serial numbers in a single cell before each char (10)

5:41 how to lock said count? Many thanks

what if I want 1,2, and 3 to repeat over and over? like; A - 1 B - 2 C - 3 D - 1 E - 2 F - 3 etc...

when I use ROW formula and COUNTA formula every second number is missing from the cell. Can you tell me what I am doing wrong please

@ksdnsdkumar1375

4 жыл бұрын

please post your doubt at superuser.com

How to fill number series like 1.2,1.3,1.4 and 1a,1b,1c

@trumpexcel

5 ай бұрын

You can 1.1, 1.2, 1.3 using fill handle. Enter 1.1 in one cell adn 1.2 in cell below, then select both the cells and drag the fill handle down. 1a, 1b, 1c is tricky as fill handle doesn't recognize alphabets the same way

@1:06 If I double click then nothing happens. I am using 2013 office.

Double click feature doesn’t work and series is grayed out. Unbelievable. 😫

5:51 How did you lock the reference ?

@trumpexcel

Жыл бұрын

By pressing the F4 key

@pranavmanohaur391

Жыл бұрын

@@trumpexcel Thank you

Sr, share this Excel File

How to protect a shared workbook.

how to lock 1 row,column..?

@sunithabhaskar8426

5 жыл бұрын

Yes i have same doubt

Sir how to open 2 eXcel sheet in one time and working

Sub total fuction is wrong

didn't work for me. Thanks anyway