excel

Excel XLOOKUP Function

Summary The Excel XLOOKUP function is a modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP.  XLOOKUP supports approximate and exact matching, wildcards (* ?) for partial matches, and lookups in vertical or horizontal ranges. Purpose Lookup values in range or array Return value Matching value(s) from...

Continue reading...

Gỡ bỏ password protected Excel

Chạy VB Editor (Alt+F11) Double Click sheet đang protected , dán đoạn code dưới đây vào và nhấn F5. Sub PasswordBreaker() If ActiveSheet.ProtectContents = False Then MsgBox “Sheet ‘” & ActiveSheet.Name & “‘ is unprotected!”, vbInformation Else If MsgBox(“Sheet ‘” & ActiveSheet.Name & “‘ dang bi khoa, ban co muon...

Continue reading...