PERFECT EXPLANATION, AND I FOLLOWED EVERY STEP YOU SAID AND I GOT MY OWN ATTNEDENCE SHEET, THANKS FOR THAT. I USE IT AS A TEACHER. THAT IS VERY HELPFUL, THANKS AGAIN. (BUT I HAVE SOME PROBLEMS, IF YOU CAN HELP ME, I WOULD BE REALLY HAPPY, I WAIT YOUR REPLY, THANKS IN ADVANCE.)

Thank you so much for your help and Explanation for this. ❤

❤

Thank you so much!

Is there a formula for military time?

Can HSTACK function be done manually or be replaced by some other formula?

Thanks. This is handy

Thanks your videos are superb.

Great vid as usual!!!

Great video!, was super easy to follow along

Is there any way to give a "ranking" to each participant so you can randomly "balance" the teams for strengths/weaknesses

What is the formula to change the year on the calendar sheet to reflect and update the events from year to year, ie:- 2024 to 2025? Please reply

Good morning, thanks for the video, I need your help because I follow steps by steps but when I tried to enter the formula on data validation, excel show me an error message that I need to type apostrophe before an equal . I do it but I cannot see the list just show me on the cell the name, and I cannot do it anything after that

Is it possible to have the searched data highlighted in the data section it was pulled from

Thank you so much for this video. I tried it out, but I am getting a different color in my 'Remaining %' column. I cant spot what I am leaving out.

Thank you so much... So useful

works perfectly for me and your directions were clear and easily understood

the first formula is wrong, even using ; instead of , i stopped there

Hi Ryan, I am trying to count colored cells not in one but in various columns (in a calendar, trying to count the attendance of a student). I was wondering if you could help, please?

Thank you so much bro you are a lifesaver fr i have a lil question if there are too many employees how to add a separate row to calculate number of employees & also the first employee's name starts from row 7 how to make it start from number to 1 to so on & so forth!!

bro! you the man!!!

Wonderful. Can you do a video on how to create a searchable directory? Thanks!

Hi i am having a problem with the formula, that you enter into cell C7 in the setup page, it only refrences the cells in the first arguement ($I$3=0,$I$4=0), after this it does not reference the next cells in the formula $B7. And just gives me an error at the end of the formula when i press enter! Any help would be apriciated Kind Regards

best video

i dont know what happen but my events doesnt connect in the calendar😢😢😢

Thanks, KZbin algorithm for sending me here!!!! I'm so happy because I've finally found someone whose video and steps were straightforward and to the point!!!! Plus, your voice is very soothing!

So helpful. Thank you

Hello, please can you help. The formula isn't really working, when i press the F4 it doesn't change it just keeps showing the F4. Sorry for the disturbance.

Nothing works on my google docs youve suggested can you upload something worthy

how to find the column number and row number at minute 3:53?

Using Excel for Mac and getting NAME error on IFNA formula. Can you help?

In the "Look Up" page can we not print all the rows? We don't want some of the information to be printed but surely want to keep the information in our records. I hope that rows can be customized to print.

I've done this and now on my events sheet (I've extended the dates to include all of next year) there are a bunch that are showing up as ################ How do I fix this?

This is great - very helpful, thank you!

Thank you!

This was a great tutorial. Thank you so much for sharing. Already put my calendar to good use :)

I followed all the steps, but in my case, every 2nd row of 7 -14 rows is not in sync on my sheet, so the tracked results aren't 100!!!

BRILLIANT

I apologize if this has been answered, but how can I password protect the file?

Hi is it possible to use similar formulas for Fiscal Year

can you do this in google sheets please

How would I edit the formula to create a calendar to just show week days (Monday to Friday) thx

Love the video. How can I add salary calculations to this?

Thank you for this tutorial....Can normal window excel be used to achieve this as well

Hello, thankyou for the tutorial! It really helped. Can you also also tell me what to do if the event date is like a period for eg: 02nd - 06th October 2024. Please reply

I tried on Google Sheet, but the event I created doesn't appear on the calendar. Is the formula used in Google Sheets different? Please help me

Hello sir, thank so much you for this tutorial..

Hi, I really like the organization of this spreadsheet however the issue that I'm running into is it does not account for scheduled days. Is there any way to edit it to include different scheduled days on and off for each associate?

hi ryan, once again, you have made a very good impression on all of us with this tutorial! thanks for sharing. a couple of months ago I made a similar spreadsheet for my PW and other personal data. In this time the database as grown to about 100 rows, which makes things somewhat harder to use the dropdown list. is there any way to search the 'description' column? that would be simply awesome! have a great day, colin

followed this to the letter, however the end date formula keeps showing this error Function WORKDAY parameter 1 expects number values. But '24/06/2024' is a text and cannot be coerced to a number.