Found 55 bookmarks
Newest
Unprotect a Word form easily, even without the password | Examiner.com
Unprotect a Word form easily, even without the password | Examiner.com
Great tip for unprotecting a Word form when you don't have the password, by inserting the text of the file into a new blank document. This gives you the form but without protection turned on. Useful if you need to clear out all form fields at once to reset a form to blank. Once you get the form unprotected, you can use the Reset Form Fields button on the Developer toolbar.
·examiner.com·
Unprotect a Word form easily, even without the password | Examiner.com
Excel Blog - Using multiple criteria in Excel Lookup formulas
Excel Blog - Using multiple criteria in Excel Lookup formulas
Good introduction to the different options for lookup formulas in Excel when you need more than one criteria and therefore can't use VLOOKUP. Shows SUMPRODUCT, SUMPRODUCT with INDEX and ROW, LOOKUP, and an array formula with INDEX & MATCH. SUMIFS would work in some situations shown too.
·blogs.office.com·
Excel Blog - Using multiple criteria in Excel Lookup formulas