How to Add Days to Dates in Excel
3:45
Automatic Serial Number in Excel
3:19
Пікірлер
@typhoon2620
@typhoon2620 2 күн бұрын
it worked thank you
@YogeshKanwadia
@YogeshKanwadia 10 күн бұрын
Can we use in Microsoft Excel sheet
@jxcrypt
@jxcrypt 11 күн бұрын
Is not automatic
@sarabjeetsinghbaweja
@sarabjeetsinghbaweja 12 күн бұрын
Cell format btaya he ni
@LacerdaJPF
@LacerdaJPF 14 күн бұрын
Thank you, well explained.
@sravanparipati494
@sravanparipati494 14 күн бұрын
Thank you.
@rajeshbabu7228
@rajeshbabu7228 19 күн бұрын
Hi, Not able to find duplicates for 18 digits. Could you please help me to find
@Adair3327
@Adair3327 21 күн бұрын
thanks!
@SaudiDoor-x9s
@SaudiDoor-x9s 24 күн бұрын
thank you, it's really helpful !
@imhere866
@imhere866 25 күн бұрын
Ye automatic kaise hogya?
@Mohamm3dAlObaidi
@Mohamm3dAlObaidi 28 күн бұрын
Thank you sir
@mohinipawar420
@mohinipawar420 Ай бұрын
Thank u
@choice1239
@choice1239 Ай бұрын
Thank you so much for valuable information dear
@pasha-bhai
@pasha-bhai Ай бұрын
wrong calculation 😅
@karthikarthikarthi9586
@karthikarthikarthi9586 Ай бұрын
Formala not working
@rohitnarasinhakulkarni4206
@rohitnarasinhakulkarni4206 Ай бұрын
Thanks
@DCInfrastructureMungeli
@DCInfrastructureMungeli Ай бұрын
WE ARE FACING ERROR prblem
@sabrinawhiteman3396
@sabrinawhiteman3396 Ай бұрын
You saved me and my colleague so much anguish. The faculty in our department will not have an excuse not knowing when we have events and double booking. Woo hoo!
@nobodyonlyboss
@nobodyonlyboss Ай бұрын
sending love
@shymivarghese8809
@shymivarghese8809 Ай бұрын
How to do the freezing?
@vishnukumar-mj9nm
@vishnukumar-mj9nm Ай бұрын
Koi batayega 8.75 kitna tym hua
@kavinduramanayake2166
@kavinduramanayake2166 Ай бұрын
Very simple and easy ,hank you very much
@jahnavikanchustambam5172
@jahnavikanchustambam5172 Ай бұрын
Thanks a ton
@mayechisavali1919
@mayechisavali1919 Ай бұрын
GOOD KNOWLEDGE SIR
@karamojainternational5217
@karamojainternational5217 Ай бұрын
On monday the normal calculation gives you 9 hours and 15minutes then where did you get 25minutes
@alfredsolo7886
@alfredsolo7886 Ай бұрын
It's percentage not minutes. 15 minutes is 25% of an hour, therefore 9:15 is 9.25
@masoodnkhan1
@masoodnkhan1 Ай бұрын
thks, it helped a lot!
@axelnordstrom7549
@axelnordstrom7549 Ай бұрын
Best I have seen. You are a king, Thanks!
@roblouzon4811
@roblouzon4811 Ай бұрын
what is the format of the cells in column C and D?
@Riyavlogs_24
@Riyavlogs_24 Ай бұрын
Thank you
@l.b.pradhan3832
@l.b.pradhan3832 Ай бұрын
Brother, how can we have 8 hr.75 mins. It should have been 9 hrs15 mins. I think you got to do some homework before making yourself a fool
@uditrana3159
@uditrana3159 Ай бұрын
Best video found on this topic
@tourismhotspots
@tourismhotspots Ай бұрын
Valuable video for learning creation of Category in Excel
@DDIzenhowa
@DDIzenhowa Ай бұрын
Great work mate - best solution I’ve seen
@TrufinAdvisors
@TrufinAdvisors Ай бұрын
How to send in a whatsapp group?
@gerilong7380
@gerilong7380 Ай бұрын
Nice and easy. Thank you
@sasidharanm8779
@sasidharanm8779 Ай бұрын
Can we use unique function for this
@musakibwana4596
@musakibwana4596 Ай бұрын
How come in my excell 2010 the list shows value only in the first cell even after erasing the $ sign?
@SHIJUSASIDHARAN
@SHIJUSASIDHARAN Ай бұрын
Great , Thank You very much , Hugs
@bharathau8085
@bharathau8085 2 ай бұрын
Thank you for the video. I was looking for this.
@staninjapan07
@staninjapan07 2 ай бұрын
Thank you. I have been trying to do something similar with SUM / INDEX / MATCH / LARGE functions, as I was advised in the first video I tried. But I, too, have the ranking problem where, if there are two identical values, Excel deletes one of the two items whose values are identical. I will rethink the whole mini-project from the start using your RANK and COUNTIF idea. Here goes... SUCCESS! SUCCESS! SUCCESS! SUCCESS! SUCCESS! SUCCESS! SUCCESS! SUCCESS! It took me hours to get to the point where I chose to use a different method - your method. It took me about 90 minutes to copy you, as, after many failures, I decided to copy EXACTLY your sheet's layout. So when you said Column A Row 1, I did exactly the same, without trying to adjust the cell references. Now, after watching your video about 15 times, stopping and rewiding a few seconds every time you did something, I have what I want, including the COUNTIF function, which has removed the errors based on duplicates. I have 15 rows of data, not six, but I have managed to adject the formulas to include all the data. Now I can do a lesson for my English students in which we can rank the importance of items for an emergency bag for disaster preparation. THANK YOU FROM JAPAN! I have a policy of not subscribing to a channel after watching just one video. I have subscribed to yours and visited your website.
@staninjapan07
@staninjapan07 2 ай бұрын
I am going to try to use your COUNTIF advise with my original sheet, too. Not today, as I have no more time, but another day. Then I will tell you, in this thread, if I had success. I will try to use your advise with these formulae... =LARGE($B$2:$B$16, J2) =INDEX($A$2:$A$16, MATCH(LARGE($B$2:$B$16, J2), $B$2:$B$16, 0))
@simwiz4903
@simwiz4903 2 ай бұрын
how do i get microsoft office for mac like how you did yours?
@Lowered_Gadh
@Lowered_Gadh 2 ай бұрын
Why doesn't Microsoft Excel formulate a simple function which brings you automatically to the "cell" you are looking for? This is a certified $1M question I guess?
@Moon-cu1nw
@Moon-cu1nw 2 ай бұрын
Thank you sir, Highly APPRECIATED!!!
@reubenedgarrayala
@reubenedgarrayala 2 ай бұрын
Can you send the email by schedule automatically?\
@alancant8501
@alancant8501 2 ай бұрын
Brilliant Thank you
@yellowrapture929
@yellowrapture929 2 ай бұрын
This is really helpful and I love how you break it down into small chunks so we can understand.
@kalivaradhanm.5481
@kalivaradhanm.5481 2 ай бұрын
EXCELLENT!
@accounts-o4e
@accounts-o4e 2 ай бұрын
friday working HRS ????? how can minutes be more than 60mins???? its wrong
@moincad
@moincad 2 ай бұрын
NICE. THANKS
@haidertalib9206
@haidertalib9206 2 ай бұрын
How can the cumulative time difference between (4:00 pm - 9:00 am) be collected at the end of a month? especially if you have 100 employees