SUMIF across multiple sheets

categories Excel Formulas | 4 views

Creating a list of unique values

categories Excel Formulas | 132 views | Tags: array, create, formula, list, unique, values

Find last row containing data

categories VBA Snippets | 95 views

Use SUMIF on a column defined by MATCH

categories Excel Formulas | 216 views | Tags: changing, columns, find, header, indirect, match, sumif, variable

Identify formulas using Conditional Formatting

categories Excel Tips & Tricks | 135 views | Tags: conditional, containing, format, formula, formulas, highlight

Highlight unprotected cells in a sheet

categories Excel Tips & Tricks | 163 views

Outlook: Flagged emails from personal folder in task list

categories Uncategorized | 515 views | Tags: display, flag, flagged, follow, follow-up, items, list, microsoft, not, outlook, showing, task, taskbar, up

Clear old filter items in pivot table

categories Excel Tips & Tricks | 545 views | Tags: clear, excel, filter, items, old, options, pivot, vba

Using Group/Ungroup in protected worksheets

categories VBA Snippets | 877 views

Crack Sheet Protection Password

categories VBA Snippets | 826 views | Tags: crack, crack hack sheet protection password excel, excel, hack, lost, password, protection, sheet
 Page 1 of 5  1  2  3  4  5 »

RSS  Entries RSS | Comments RSS

  • Categories

    • Excel Add-In
    • Excel Formulas
    • Excel Tips & Tricks
    • Uncategorized
    • VBA Snippets
  • Pages

    • About
    • Excel Shortcuts
  • Favorite Links

    • Code For Excel And Outlook Blog
    • Ozgrid.com
    • Ron de Bruin