ANDREW'S EXCEL TIPS


FORMULAS	FORMATTING	SHORTCUTS	VBA
About Array Formulas	Colour Even Rows	Alt Keys	Custom Functions
	Colour Odd Rows	Ctrl Keys	GetFormula
Dates, Time and Age	Colour Set Rows	Function Keys	GetColor
Add Months (EDATE)	Colour Rows with Filter	Shift Key	GetFormat
Age Calculation	Dates & Time	AutoShapes	SheetName
Age Check	Fractions	Sheets	BookName
Count Weekdays	Numbers & Currency	Multiple Entry	FullName
Count Hours	Show Incorrect Entry		HasFormula
Get Weekday Date	Variable Format		HasText
Calculate Shipping Date	Zeros in front of Numbers		GetComment
First of Month	Hide Zeros		GetFont
Last of Month (EOMONTH)	Hide Entries		IsColor
Instant Calendar	Hide Errors		CountColor
List Month Days	Hide Formulas		RowSize
Week Number (Absolute)	Align Decimals		ColumnSize
Week Number (ISO)	Fill Cell		GetNumbers
Week Number (WEEKNUM)	Singular & Plural		GetText
ISO New Year	Find Protected Cells		JoinText
ISO Week Count	Find Formulas
Current Date	Protect Formulas		Comments
Get Day	Find Duplicates		Autofit Comments (Sheet)
Get Month	Find Unique Values		Autofit Comments (Selection)
Get Year			Cell Text To Comment
Get Quarter			Comment Height
Detect Leap Years			Show Comments
Count Leap Years			Hide Comments
Avoid Weekends			Reposition Comments (Sheet)
Floating Dates			Reposition Comments (Selection)
Get Weekday Occurence			Add Rounded Comment
Decimal Time			Add Comment With Text
			Font Size
Text and Numbers
Count and Add with Criteria			Worksheets
Count Characters in Single Cell			Show All Sheets
Count Characters in Range			Hide Active Sheet
Count Words in Single Cell			Hide Selected Sheets
Count Words in Range			Auto_Open (Unlocked Cells)
Count Numbers in Range			Auto_Open (Select Cell A1)
Count Text in Range			Protect Worksheets
Find Text in Range			Protect Worksheets
Remove Numbers from Left			Unprotect All Sheets
Remove Numbers from Right			Change Sheet Name
Remove Text from Left			Select All Objects
Remove Text from Right			Delete All Objects
Remove Currency			Group All Objects
Remove All Decimals			Select Used Range
Remove Certain Decimals
Round to Nearest 5 Cents			Toggles
Find the Decimal			Display Formulas
Ordinal Numbers			Show Zeroes
Find Maximum using Criteria			Toggle Gridlines
Find Minimum using Criteria			Toggle Display Headings
Find 3rd Largest using Criteria			Toggle Scroll Bars
Sum Every 3rd Row			Toggle Workbook Tabs
Sum 3 Largest Numbers			Toggle Status Bar
Find 3 Largest Numbers			Toggle Formula Bar
Convert to Feet & Inches
Basic Trigonometry			Conditional Select
Random Numbers			Select by Color
Ignore Errors (or Text)			Select by Value
Count Errors			Select between Values
Ignore Zeros			Select Cells With Formulas
Ignore Duplicates
Number Duplicates (Single)			Message Boxes
Number Duplicates (Multiple)			Message Box Examples
Count Unique Values
Count Duplicates			Events
Count If Similar			BeforeSave Example
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

Copyright andrewsexceltips.net. All Rights Reserved