Video

You can try combining the data into a single master sheet to simplify the vlookup. Here is a video that can be useful: czcams.com/video/JYZ5MR6e6Qs/video.html

@@3aslogisticspakistan538 Thank you for this lovely feedback and thank you for the blessings.

@@venkateshchintagunti4236 thank you for the feedback. Please let me know if you have any questions for me so I can help you with that.

@@Syedhussainipage there is no problem 1 or 2 sheets, but 3rd sheet couldn't work and I have done same as you but it's not working. for 3 Days I have been trying 'n/a is coming'

@@venkateshchintagunti4236 would it be convenient for you to get on a zoom call and use your sample data so I can help you understand how it works? If yes, please use the following link to book time with me as per your convenience meetings.hubspot.com/syed57?uuid=5cb6d038-abcc-4d3b-b586-82c2beccb0d4

@@venkateshchintagunti4236 would you be able to share a sample data with the steps that you performing so I can take a look? You can share the data using the following link forms.gle/7SAitfb8UmQyYorh9

@@dandan9175 please let me know what is in the A3. Also, if you can please share a copy of your data as a sample for my reference. Use this form to share sample file forms.gle/DGXWd7Cc9u11GPao9

Glad you liked it!

Yes, you can do that in the older versions of Excel as well. Let me know if you need any help.

Thank you for the helpful feedback.

I saw that on a regular unpaid version too recently. Let me share a screenshot with you shortly. I am driving at the moment.

@@dasistpfui I discovered that it is now available to all the users. Earlier it was only for the paid Google workspace subscriptions. Now it is made available to all the users of Google sheets. Please let me know if you do not see it.

@@Syedhussainipage Thanks for share this great news :) i see it works 🙏

Hey there, I have posted a step-by-step process to achieve this here: onlineknowledgeportal.com/2024/06/14/show-the-time-difference-in-excel-in-minutes-only/ Please let me know how it goes.

@@Syedhussainipage Thank you for your reply! When I apply the formula =(xx - xx) * 1440 to my time frame, it comes back with 00:00. My times are formulated to hh:mm. I work in food manufacturing and the operators are not calculating regrind the same way each time, as they should be, so I want to create an Excel calculator for them. They would input the time frame and get the correct minutes back that they would use to calculate the regrind. The shifts are 12hrs (0700-1900) and (1900 to 0700).

@@maryellenbrooks2921 Can you share a sample data with me so I can take a look. You can also book a time slot for a quick Zoom call so I can help you. You can use this link to book 15/30 minutes: meetings.hubspot.com/syed57

@@Syedhussainipage I did not get a notification that you had replied, so thank you for waiting for me. I want to calculate the minutes between press start to time product was called good. i.e..operators would enter the press start 07:22 to good product 08:01. When I use your formula (08:01-07:22)*1440 it returns an answer of 0:00. It should say 0:39 min.

@@Syedhussainipage I figured it out! I am going to use the calculation that I found and just input the hour and the minutes in separate cells and then the formula I found works perfectly. Thank you for being available, and willing, to answer questions.

I just discovered that the option for Tables is currently available to Google Workspace Paid edition only. support.google.com/docs/thread/274482551?hl=en It will soon be available to all. 🤞🏼

@@hbp7633 I discovered recently the tables option is now available to all users of Google sheets.

Thank you for the helpful feedback. It is motivating. If you haven't already, please subscribe for regular updates.

Here is the next video: czcams.com/video/wFq3EnZSr4s/video.html

Thank you for this amazing feedback! It truly helps in keeping me motivated.

Thank you for the helpful feedback. This helps in keeping me motivated. If you haven't already, please subscribe to my channel for regular updates. Best Regards, Syed H

@@Syedhussainipage all ready done sir

I will get this done in a few days using these functions and will drop a comment here to keep you posted.

Thank you for your feedback. This helps in keeping me motivated. If you haven't already, please subscribe to my channel. Best Regards, Syed H

I am happy to help!

Yes, I will post a video about it tomorrow. Please let me know if there is something specific you want me to consider in the tutorial.

@@Syedhussainipage sir thanks for your kind ness.Can u make any video about cell referencing. That matter is not clearing to me.for this reason i facing problem when i using advance vlookup.

@@asifquader8447 How about a quick 15 mins zoom call? I can help you gain more clarity on that.

@@Syedhussainipage thanks sir.that will be helpful

Here is a link to book time meetings.hubspot.com/syed57?uuid=6684d994-9348-414c-b151-86cbd01354f8

By the way, thanks for including the Mac shortcuts. So many excel videos leave this out.

I have revised the script further. I also added steps to change the currency when needed. onlineknowledgeportal.com/2024/05/25/number-to-words-in-excel/ Please take a look and let me know.

Thank you for letting me know that. I understand the issue. The problem arises because the script is not properly handling the segments and placing them in the correct position. We can adjust the script to ensure that the larger numbers are placed correctly and do not result in incorrect concatenation like "One Million Thousand." I have updated the script on the Post: onlineknowledgeportal.com/2024/05/25/number-to-words-in-excel/. Please take a look and let me know.