Відео

@@tpnphoonsiri Glad it helps

if your data is number, you could use the same method. It could be a difficulet situation, when the data is not a number. To test it - use ISNUMBER function on your data. See whether it's TRUE or FALSE. Hope this helps.

@@DianaN-go8mo Seek support from colleagues. I hope this solution could help you

@@MCSETrainingAndEvents I'm delighted to see your excitement 😁

@@vyshnavikandala3147 That's because Excel is taking time to open and save it. I believe it does take a while to open close to 1 GB file. Since it's automated, you could let it runs overnight. Hope it helps

@@aungmin6210 The calculation just sums of each trait. There are few online resources on this. You could get them with a quick search. Hope it helps

@@muhammadakmalwong7123 I'm happy it helps 😁

@@cxoxoaz Formatting code for your testing [>=1000000000]"+65"00-0000 0000;[>=100000000]"+65"00-000 0000 Hope this helps

@@ExcelSifu it gives me ######### like this hmm eventho i drag the column width hmm

This does not repeat the number. Any retionale you want to have repeating numbers?

@@MohdsaliheanSalim I'm happy it helps

@@antoblockz7806 I'm glad you like it.

@@sophykeo9639 My pleasure to share

@@sophykeo9639 I'm happy you like it

You can train ai by giving it appropriate examples. ai works better with examples. Hope this helps.

@@ExcelSifu can see sifu build a youtube video plz hehe

I'm gladful it really helps you.

@@falconjgc I'm delighted that this video helps

@@Sutinah-t1v 1. Right click on the cell 2. Format Cells 3. Number 4. Custom If you are not able to see that, do ensure you're using Microsoft Excel.

@@RESHMANAMPALLI You could recreate the file with ease. By doing so, you can polish your skill. Hope this supports you in getting better in Excel.

@@ardaqs2694 Thanks for your encouragement

@@JankoVlada glad it helps 🙏🏻

@@TTTray13467 good question If you need more than 1 quote a day, you could add on the hour, minutes and second. Alternatively, you can have sequential number of the date.

I'm glad it helps you 💪🏻💪🏻💪🏻

I'm delighted that this solution works for you. 💪🏻🙏🏻👍🏻

I am not sure when you want to reset it. The sample in the video, reset the row when the user enter something. If you want to use the code to reset all existing rows with a click, you can use for each Or Do while To loop all existing row. Hope this gives you some ideas

@@ExcelSifu I have a column with independent drop down list column B and D, then in columns C and E (respectively) there are dependent drop downs. I want when a user changes the selection in columns B and D that it resets the values in columns C and E with a message saying "please, select"

Private Sub Worksheet_Change3(ByVal Target As Range) Dim BRange As Range Dim DRange As Range Dim CRange As Range Dim ERange As Range Dim cell As Range Set BRange = Me.Range("B:B") Set DRange = Me.Range("D:D") Set CRange = Me.Range("C:C") Set ERange = Me.Range("E:E") If Not Intersect(Target, BRange) Is Nothing Then Application.EnableEvents = False For Each cell In CRange If cell.Row > 1 Then cell.ClearContents End If Next cell Application.EnableEvents = True End If If Not Intersect(Target, DRange) Is Nothing Then Application.EnableEvents = False For Each cell In ERange If cell.Row > 1 Then cell.ClearContents End If Next cell Application.EnableEvents = True End If End Sub Private Sub Worksheet_Change4(ByVal Target As Range) If Target.Column = 2 Then Target.Offset.Column = 3 = "Please Select..." End If End Sub This is what I have right now but it's not running or working. Not sure what I am doing wrong.

Harap ini boleh bantu anda

I'm happy that helps. 🙏🙏

As XLSM won't save macro. Thus, you need to adjust the code to save the file to XLSM or other macro-supported file formats. Hope this helps.

Could you provide some samples and the expected results?

@@ExcelSifu yes

I need some information from you, can you help me?

Sir is your whatsapp number.

Do you have some samples and also the expected outcome?

Hi, could you give me more details on this. Is the rate fixed for daily calculation or ...?

There could be typo on the link. Double check on the URL. Hope this helps

Presume the data is on cell A1, you could test with formula below =IF(LEFT(A1)="6", MID(A1,2,100), A1) Hope this helps.

You're right on your opinion 😁

I'm happy it helps

The easiest way is to filter that in your file explorer to old Excel file and then delete them. Hope this helps

@@ExcelSifu thanks for your reply but i have multiple folder with old excel file, your macro was helpfull to create new excel with latest version but with original file as well, could you please help on to removed those old version original excel file

Question - Does the phone number could be either a landline or a mobile phone number? Because both have different number of digits.

Formatting code mentioned in the video that is usable for Singapore [>=1000000000]"+65"00-0000 0000;[>=100000000]"+65"00-000 0000

I'm happy it helps. 😁😁

Sure. It works too. Give it a go and let me know the results ya

I'm happy this helps 😁

I'm happy that it helps 🙏🏻

These are quick steps 1. Have a table that associate numbers to states 2. Extract the number from NRIC 3. VLOOKUP that number against table 1 above Hope this gives you some ideas.

Thanks for your encouragement 🙏🏻🙏🏻🙏🏻

Presumably the data is at cell A2 ="6" & SUBSTITUTE (SUBSTITUTE (A2," ",""),"-","") Hope this helps 😁

@ExcelSifu Hi Sifu, I have tried to follow your suggestion in excel, however [ ="6" & SUBSTITUTE (SUBSTITUTE (A2," ",""),"-","")] is just removed the "-" and space, so the results of the formula is 60131234567 but not 60-131234567, may I ask is it possible to add the "-" after 60.

But I find a way to do it, after formula that sifu suggested then add one more replace formula =replace(A2,3,0,"-") then the "-" will add into after 60 @@ExcelSifu

@@信李-f1h brilliant 👍🏻👍🏻👍🏻