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, … Read more

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 … Read more