Thẻ: 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 return array Syntax =XLOOKUP (lookup,…
-
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 go bo khong?”, _ vbYesNo…