Back to Home PageEmail me
Microsoft Most Valuable Professional
One-Stop-Formula-Shop...Excel Tips BlogExcel Tips in Japanese...Random Ravings...Download My Add-insWho am ! ?JMT Micorosoft Excel QA BoardJMT Consulting  
Formulas, Formats, Shortcuts and VBA (Updated: July 13, 2007)

Formulas

  • About Array Formulas


    • Dates, Time and Age
  • Add Months (EDATE)
  • Age Calculation
  • Age Check
  • Count Weekdays
  • Count Hours
  • Get Weekday Date
  • Calculate Shipping Date
  • First of Month
  • Last of Month (EOMONTH)
  • Instant Calendar
  • List Month Days
  • Week Number (Absolute)
  • Week Number (ISO)
  • Week Number (WEEKNUM)
  • ISO New Year
  • ISO Week Count
  • Current Date
  • Get Day
  • Get Month
  • Get Year
  • Get Quarter
  • Detect Leap Years
  • Count Leap Years
  • Avoid Weekends
  • Floating Dates
  • Get Weekday Occurence
  • Decimal Time


    • Text & Numbers
  • Count and Add with Criteria
  • Count Characters in Single Cell
  • Count Characters in Range
  • Count Words in Single Cell
  • Count Words in Range
  • Count Numbers in Range
  • Count Text in Range
  • Find Text in Range
  • Remove Numbers from Left
  • Remove Numbers from Right
  • Remove Text from Left
  • Remove Text from Right
  • Remove Currency
  • Remove All Decimals
  • Remove Certain Decimals
  • Round to Nearest 5 Cents
  • Find the Decimal
  • Ordinal Numbers
  • Find Maximum using Criteria
  • Find Minimum using Criteria
  • Find 3rd Largest using Criteria
  • Sum Every 3rd Row
  • Sum 3 Largest Numbers
  • Find 3 Largest Numbers
  • Convert to Feet & Inches
  • Basic Trigonometry
  • Random Numbers
  • Ignore Errors (or Text)
  • Count Errors
  • Ignore Zeros
  • Ignore Duplicates
  • Number Duplicates (Single)
  • Number Duplicates (Multiple)
  • Count Unique Values
  • Count Duplicates
  • Count If Similar
  • TRUE if Similar
  • Match If Similar
  • Get Nth Word
  • Get Last Word
  • Get First Name
  • Get Middle Name
  • Get Last Name


    • Reference
  • Compare Lists 1
  • Compare Lists 2
  • Find Cell Reference
  • Find Column Letter
  • Find First Cell Address
  • Find First Cell Value
  • Find Last Cell Address
  • Find Last Cell Value
  • Find Maximum Address
  • Find 3 Largest Values Addresses
  • Multiple Criteria Lookup
  • Show Every 3rd Row
  • Nested Ifs Workaround
  • Show Extra Rows
  • Instant Row Numbers
  • Reference Dates
  • Remove Blanks
  • Reverse List
  • Randomize List


    • Formats
  • Colour Even Rows
  • Colour Odd Rows
  • Colour Set Rows
  • Colour Rows with Filter
  • Dates & Time
  • Fractions
  • Numbers & Currency
  • Show Incorrect Entry
  • Variable Format
  • Zeros in front of Numbers
  • Hide Zeros
  • Hide Entries
    • Hide Errors
    • Hide Formulas
  • Align Decimals
  • Fill Cell
  • Singular & Plural
    • Find Protected Cells
    • Find Formulas
    • Protect Formulas
  • Find Duplicates
  • Find Unique Values


    • Shortcuts
  • Alt Keys
  • Ctrl Keys
  • Function Keys
  • Shift Key
  • AutoShapes
  • Sheets
  • Multiple Entry


    • Visual Basic for Applications

    Custom Functions
  • GetFormula
  • GetColor
  • GetFormat
  • SheetName
  • BookName
  • FullName
  • HasFormula
  • HasText
  • GetComment
  • GetFont
  • IsColor
  • CountColor
  • RowSize
  • ColumnSize
  • GetNumbers
  • GetText
  • JoinText


    • Comments
  • Autofit Comments (Sheet)
  • Autofit Comments (Selection)
  • Cell Text To Comment
  • Comment Height
  • Show Comments
  • Hide Comments
  • Reposition Comments (Sheet)
  • Reposition Comments (Selection)
  • Add Rounded Comment
  • Add Comment With Text
  • Font Size


    • Worksheets
  • Show All Sheets
  • Hide Active Sheet
  • Hide Selected Sheets
  • Auto_Open (Unlocked Cells)
  • Auto_Open (Select Cell A1)
  • Protect Worksheets
  • Unprotect All Sheets
  • Change Sheet Name
  • Select All Objects
  • Delete All Objects
  • Group All Objects
  • Select Used Range


    • Toggles
  • Display Formulas
  • Show Zeroes
  • Toggle Gridlines
  • Toggle Display Headings
  • Toggle Scroll Bars
  • Toggle Workbook Tabs
  • Toggle Status Bar
  • Toggle Formula Bar


    • Conditional Select
  • Select by Color
  • Select by Value
  • Select between Values
  • Select Cells With Formulas


    • Message Boxes
  • Message Box Examples


    • Events
  • BeforeSave Example


    • Go to Top


    HOME    F-F SHORTCUTS    Excel Tips    JAPANESE SITE    MY SCRAPBOOK    DOWNLOADS    SELF-INTRODUCTION    FORUM


    Copyright 2004 - 2007, andrewsexceltips.com. All Rights Reserved