Hi alansidman

Thank you so much! Your explanation is correct and I understand it well. However, I keep getting these errors to some of those date/time.



Does this mean I can't change the date/time for those in errors?

Thank you so much!

My apologies. Here you go! Thank you so much!

Hi there,

I have a data that shows date/time data. Currently, I couldn't transform the date/time format into a specific one due to unknown reasons.



As you can see above, some of the date/time are in different formats. Whenever I tried to change the date/time format through TEXT Formula or through cells formatting, it doesn't seem to work well.



The date/time format should be in "MM/DD/YYYY" which only works on certain cells.

Are there any ways I can further change the date/time format here? Thank you very much!

Hi rory ,

thank you! it works!

Hi there,

I have a file that I would need to group the time into a specific shift. For example,

6.45am to 3.15pm falls under MORNING

3.15pm to 11.45pm falls under EVENING

11.45pm to 6.45am falls under NIGHT

I managed to separate the time from the existing datetime column. However, I'm stuck with the grouping using formulas.

Is it possible to group the time into specific shifts using formulas? Thank you!

Hi there,

Thanks! The subtotal function works!

Hello everyone,

I have a data collection file with some calculation created. I would like to get my calculations (Column O) to work when I filter the table. How can I get the calculations to work when I filter the table?

Attached here is the file for your references. Appreciate the help and support from you guys here! Thank you so much!

Hi Roy,

Thanks! This works perfectly!

However, how can I automate it to the entire row of the column? Assuming if there are few rows added, will the formula work for subsequent rows?

Hi there,

Apologize for the error and confusion. Here's the updated file for you to view.

Thanks!

Hi there,

Not really.

From Column G to J, there are two "No" captured there. Therefore, it should be counted as 2 in the column J there.

Hi there,

Here's the attached file.

Thanks!

Hi everyone,

I would like to achieve a COUNTIFS Function on 3 columns as per the attachment. If the criteria is NO, then it counts as 1 per row.

How can I achieve this in Excel? Currently I'm using COUNTIFS Function tho it's not really working as it is.

Thanks!

Thanks royUK. I have enabled password protection for the worksheet.

Just to add on, here's the full code I designed for the form.

Can we actually make a textbox data from a userform not editable when it is transferred to a column? I have a textbox that collects current date and time when it's submitted. When submitting the form, user will not be able to write or select any date as it comes automatically. (Refer photo below).

However, user can change the date and time after it has been submitted. The only way I can think of is to lock the cells for editing.

Are there any options besides locking the column? Thanks for your support!

Hey Roy!

Thank you so much! It worked now!

Hello everyone,

I made a simple userform for the purpose of collecting data. I managed to get all buttons working except the submit button. I'm not sure what's wrong but I'm guessing it got to do with the "values" attribute? My code is as per below.

Thank you for your support!

Hello everyone,

I have a worksheet containing a set of information and data. In the second worksheet (Worksheet B), I have summarized version of all information from worksheet A which I incorporated the COUNTIF Function to get the simplified version of the data. Each cells in Worksheet B is using the COUNTIF function since they are different to each other.

I have attached the file below. It would be good if I can get a starting line of code of the first cell. I will pickup the rest of the codes and will continue for the rest of it. Thank you so much everyone!

I see. I guess it doesn't revolve around screen updating that much.

Hello guys.

Not sure about the screen updating function here. Do I need to set it as true to enable the data to be updated automatically? Thank you!