Hi! Thanks for the great tutorial. I redid it myself, working almost perfect. If a colleague's birthday is in the next year e.g. in January 2025, they don't show up in the list. Is this a formula thing? How can I fix it that with next days=365 all birthdays show up? Thanks!
Sir your video based on Advanced formula and techniques, but i request you to give a reason why use these formula so will understand more with logic. 🙏
Thanks so much. I have done mine but each time I try copying the file to another location in my PC or to another PC, I affect the data in the excel sheet and it stops working. Please what should I do? And I can I open the file in a lower Microsoft Excel version, please show me how. Thanks
As you use for mula for location column,it is available in office 365only,if I don't have office 365 in my pc ,but I have office 2013and windows 7ultimate in this situation how to complete birthday list sheet or any alternative formula for office 2013, version please send or guide me ASAP step by step, thanks in advance
Ye to company ke employee ka birthday list sheet hai, to kya aap personal name ke liye dynamic birthday list prepare kar sakte ho pk ? If you prepare this asap then I will be thankful for you otherwise this type list no use for us
Sir good afternoon, I wouldlike to inform you that I don't have Microsoft 365, so I cannot use Unique formula and vstack formula, so how to do for location window in office 2007/2013 ? Please help me or guide me asap
Sir heavy technique
Heavy knowledge sir
No words to say sir💐💐💐🙏🙏🙏🙏
Just🙏👌💐
Thanks 🙏
Great video Thanks for sharing
Most welcome
Mind blowing work!!!
Thank you so much 😀
Amazing....great work PK. You are a master of Excel functions and formulas 👏
Thanks 🙏
Excellent ❤
Thanks 😊
Your video more informative thanks sir
Most welcome
Hi! Thanks for the great tutorial.
I redid it myself, working almost perfect.
If a colleague's birthday is in the next year e.g. in January 2025, they don't show up in the list.
Is this a formula thing? How can I fix it that with next days=365 all birthdays show up?
Thanks!
Nice and useful
Thanks a lot
tremendous proficiency
Thanks 🙏
Sir your video based on Advanced formula and techniques, but i request you to give a reason why use these formula so will understand more with logic. 🙏
How to prepare personal birthday list or table like this table? please guide me ASAP
Thanks so much. I have done mine but each time I try copying the file to another location in my PC or to another PC, I affect the data in the excel sheet and it stops working. Please what should I do? And I can I open the file in a lower Microsoft Excel version, please show me how. Thanks
As you use for mula for location column,it is available in office 365only,if I don't have office 365 in my pc ,but I have office 2013and windows 7ultimate in this situation how to complete birthday list sheet or any alternative formula for office 2013, version please send or guide me ASAP step by step, thanks in advance
Ye to company ke employee ka birthday list sheet hai, to kya aap personal name ke liye dynamic birthday list prepare kar sakte ho pk ? If you prepare this asap then I will be thankful for you otherwise this type list no use for us
hello, what if my employee name is in two columns like first name and last name. Upon searching, the names will be concatenated in 1 column. Thanks
Also facing problem while using =filter(Employee_Master,(Days_difference>=criteria_days)*Days difference
Is there any additional thing require to execute this function? Pls guide.
Video is quite good but none of use if we can not use it
Some formulae are not working with us . Why specially [ ]
Sir good afternoon, I wouldlike to inform you that I don't have Microsoft 365, so I cannot use Unique formula and vstack formula, so how to do for location window in office 2007/2013 ? Please help me or guide me asap
create interactive excel without using name range challenge (impossible)
tremendous proficiency
Thanks 🙏