CountIf limitation COUNTIF

State Abbr with Index+Match+Validation Data Validation

Calculate hours between two cells ABS

WorksheetName and WorksheetsNo UDFs Lookup and References

Cell formats 0.0\% and 0.0%;(0.0%) Format Cells

Repeated Offset Basic Math

Excel keeps converting all cells to “Date” (or Time) Excel User tips

Links between two workbooks – dynamically using functions INDIRECT