Search results

Noted with thanks. I am using Table most of the time. I will stick to range. Thanks again for your help.

Hi p456Cal, How can I modify this formula so that it works in a Excel Table? Otherwise, I'll receive a #SPILL! error.

Thanks, p45cal.

Thanks, vletm. I apologize for not mentioning that I'm seeking help of a formula rather than a pivot table. This is because I have numerous columns with other information that users must enter after the Year and Month have been extracted out to another table.

I have one table column that contains a list of date. I wanted to export each year and month to another table and ignore duplicated Year/Month. i.e. If I have 01/02/2024, 02/02/2024 , 15/02/2024 and so on, the result should have only one row that contain year 2024 and month Feb Please see the...

Thanks, Peter for the help.

I have a spreadsheet with a target set for the year 2022 in column C. The total (Jan to Dec) will be calculated in Column P. I'm attempting to perform the comparison using the formula below, to compare (extract and compare) the result with the set target, but I'm not getting the desired result...

Thanks, it works.

Is there a simple formula that will do the job in addition to the power query solution? Thanks.

I'm getting an error (#Value) when attempting to extract minutes from the largest number (Monthly Hours/Mins/Sec) and would appreciate some advice. e.g. 10974:36:26 which I wanted to extract 36 out to perform some calculation. MINUTE formula will not works. Thanks. Please see the attached file...

My apology, didn’t notice I am not using my own account as I am using my relative mobile device to reply the message.

Thanks, All. I have fixed the errors.

having a Run-time error '9'

I have an Excel workbook. In VBE, I found additional "sheets" and then when go into the properties windows, they shown me "Thisworkbook" too. How to remove them?

Thanks. It works now.

The result shows A62C/R0/CAR/19/0001 A62C for year 19 and A63C for 20, RS become R0 trying to understand how your formula works.

I will need some help on what should be the formula to use. I want column D to auto-increment when the date in column C filled. 19 represent 2019 and 20 represent 2020. The running number will start from 0001 when the year changed. Thanks.

Thanks All, All the 3 formulas work as per expected.

I want to highlight C1 to C8 at R3 and R6 only when the whole rows are with the word blank. What should be the formula to use? I used and it only hightlight the 1st cell. Thanks.

Thanks, P45Cal. An alternate method without using VBA code and it works for me. Appreciate your help too.

Thanks, PCI. I implement your code with some changes to my master worksheet and it works. Appreciate your help.

I have a set of Data in sheet "BList", with both S/No and Date code combined in one cell - a "/" in between them. I want to check and compare them with sheet "AList" - S/No and Date Code in 2 separate cells. and to show the result with Status not equal to "CAR" but Serial Number & Date Code...

Try this from Peter's formula =FV(A4/12,180,-10000,,1)

Thanks, Narayan. You help to solve the manual process and prevent human errors. Appreciate your help.

Sorry for the errors. E10 and E13 should follow Column K10 and K13. H29 - When the number found and match in the "Ref" sheet, a "yes" will be shown. I have updated the spreadsheet with the correction. Eventually, I hope to remove column K, L and H and all the results will be found in Column E...