How to Loop in Excel Formulas Without VBA
Excel formulas don’t have a FOR or WHILE loop like VBA does. But you can still make a formula repeat a calculation for every character, every row, or every step …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Convert Numbers to Words in Excel
Checks, invoices, and receipts often need the amount written out, like “One Thousand Two Hundred Eighty-Four Dollars and Thirty Cents” for 1,284.30. Excel has no built-in function that writes numbers …
How to Use IF With Cell Color in Excel
Excel’s IF function can’t look at a cell’s fill color. It only reads values, so a formula like =IF(A2 is green,…) doesn’t exist out of the box. That’s a problem …
How to Use INDEX MATCH to Return Multiple Values in Excel
INDEX MATCH is a lookup combo, but MATCH only ever finds the first row that matches. So if a value appears several times, you only get one result back. To …
Excel Flash Fill Not Working – How to Fix?
Flash Fill can turn one example into a completed column, saving you from typing or copying the same pattern row by row. When it stops working, the cause is usually …
How to Convert Julian Date to Calendar Date in Excel (5-Digit, 7-Digit, and JDE)
Converting a Julian date in Excel turns a compact year and day code into a calendar date you can read, sort, and filter. Before choosing a formula, count the digits …
Pivot Table Not Refreshing – How to Fix?
When a PivotTable does not refresh, its report can keep old totals or omit newly added records. A basic refresh works only when Excel can read the right source and …
How to Use Custom AutoFilter in Excel (AND/OR Conditions and Wildcards)
When a regular filter checklist isn’t specific enough, Custom AutoFilter lets you filter a column with operators such as Contains, Begins With, Between, and After. That helps when you’re looking …
How to Create an Aging Formula in Excel (30, 60, 90 Days)
An aging report sorts unpaid invoices by how many days they are past due. It shows which balances are current and which ones need attention. Excel can calculate the late …
How to Make Tally Marks in Excel
Tally marks give you a quick visual count of votes, survey answers, attendance, or anything else you record repeatedly. Excel has no dedicated tally button. However, a couple of formulas …
How to Use SUMIFS with INDEX MATCH in Excel
SUMIFS is a useful function when you want to add up values that meet one or more conditions, like sales for the West region. It works fine when the numbers …
Input Cell Reference Is Not Valid in Excel – How to Fix?
When you build a data table in Excel, you may run into an error that stops it before it starts. The message is: Input cell reference is not valid. It …