Sir thanks for the formula. But this formula is not working in any way. And sometimes it is giving wrong results. I have tried many times. Please help me.
Hello MItutorials, I am great fan of yours and learned lot of excel formulas by seeing your vedios. Now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets as soon as the ticket arrives we have enter the ticket number in that sheet and change the color of the cell manually according to the time the ticket arrived for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest
Thanks for sharing, really this is a great method to remove the blank row with formula but I want to know how to same method in column based . Please help if possible
Did you know how to get information from one column whitout repitition? i'm from Brazil and i'm using the formula ÚNICO, but it's don't worl when I format how table, it show the message about #DUMP!
Thanks man. I was looking for this.
The first method itself worked great for me, thanks for putting it out here.
I was searching for this for 5 hours. Thanks!
Sir, thank you very much for explanation.🤝
Sir thanks for the formula. But this formula is not working in any way. And sometimes it is giving wrong results. I have tried many times. Please help me.
Hello MItutorials,
I am great fan of yours and learned lot of excel formulas by seeing your vedios.
Now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets as soon as the ticket arrives we have enter the ticket number in that sheet and change the color of the cell manually according to the time the ticket arrived for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest
do you have same for suplicates?
Hi, do you know how to copy from a array range like from a table to a column, copy all numbers from 4 rows and 9 columns to just a column
Thanks for sharing, really this is a great method to remove the blank row with formula but I want to know how to same method in column based . Please help if possible
Thanks a lot, It was really helpful. REGARS
thank you for sharing
How do you ignore a cell if it's blank or has "N/A"?
Thanks for your valuable time. But I am unable to see the formula. So will you please write the formula here in reply
Did you know how to get information from one column whitout repitition? i'm from Brazil and i'm using the formula ÚNICO, but it's don't worl when I format how table, it show the message about #DUMP!
... but it's don't work when I format how table, it show the message about #DUMP!
Please watch this
Remove Duplicates and Copy Data to another location in Excel
ruclips.net/video/eXYHM_L2hqM/видео.html
Thanks a lot ❤️
thanks man
I wanted to implant something that removes blanks into my already existing index formula, I've found this logic is too complicated