Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel VALUE Function Not Working? Fix Text-to-Number ErrorsIf Excel’s VALUE function returns #VALUE!, the text in the cell probably is not written in a number, date, or time format…
- Excel VALUE Formula Not Working? Fix Common ErrorsIf Excel’s VALUE formula is not working, first check whether the cell contains text Excel can interpret as a number and whether…
- Excel Unique Records Only Not Working? Fix the FilterIf Excel’s Unique records only option is not giving the result you expect, check the list range first: Advanced Filter identifies unique…
- Excel UPPER Function Not Working? Fix Common CausesIf Excel’s UPPER function is not working, first check that the formula is entered as =UPPER(A2), with the text you want to…
- Excel Value Filter Not Working? Fix the Common CausesIf an Excel value filter is not working, first clear the current filter and check that the column contains consistent data and…
- Excel Transpose Paste Not Working? Fix Common CausesIf Excel’s Transpose paste is not working, copy the source cells, select one blank destination cell, then choose Home > Paste >…
- Excel UNIQUE Function Not Working? Fix Common ErrorsIf Excel’s UNIQUE function is not working, first check that your Excel version supports dynamic arrays, then inspect the formula’s spill area…
- Excel Text to Columns Date Not Working? Fix ItIf Excel Text to Columns is not converting your dates, run the wizard again and, in its final step, select the date…
- Excel TRANSPOSE Not Working? Fix the Common CausesIn Excel for Microsoft 365, enter =TRANSPOSE(A2:C4) in one empty cell and make sure the cells where the results need to appear…
- Excel TAKE Function Not Working? Fix the Common CausesIf Excel’s TAKE function is not working, first confirm that your Excel version supports it, then check the formula’s array and row…
- Excel Text Filter Not Working? Common FixesIf an Excel text filter is not working, first check that the filter covers the entire data range, then clear and reapply…
- Excel SUMIFS Not Working? Causes and FixesYes—Excel SUMIFS can return zero, the wrong total, or an error when its ranges, criteria, or data types do not line up.…
- Excel Table Filter Not Working? Fixes to TryIf an Excel table filter is not working, click its drop-down arrow and choose Clear Filter From [column], then select the values…
- Excel SUMIFS Date Range Not Working? Fix the CriteriaIf Excel SUMIFS is not summing a date range, first check that the dates are real Excel dates and that your criteria…
- Excel SUBSTITUTE Function Not Working? Fixes That HelpIf Excel’s SUBSTITUTE function is not working, check that the text you want to replace matches exactly, that the formula is entered…
- Excel SUBSTITUTE Not Working? Common FixesIf Excel’s SUBSTITUTE function is not working, the usual causes are text that does not match exactly, a difference in capitalization, a…
- Excel Sheet Hyperlink Not Working? How to Fix ItIf an Excel hyperlink seems unresponsive, first try Ctrl+clicking its cell on Windows: Excel normally uses a regular click to select a…
- Excel Sheet Filter Not Working? Fix the Common CausesIf an Excel sheet filter is not working, first clear any existing criteria, then select the complete data range—including its header row—and…
- Excel ROUND Function Not Working? Causes and FixesIf Excel’s ROUND function seems not to work, first check whether the cell contains a real number and whether the formula is…
- Excel Round Not Working? Fix the Formula and DisplayExcel’s rounding function is =ROUND(number,num_digits). If it seems not to work, check whether the source is a real number, whether the cell’s…
- Excel Number Filter Not Working? Find the FixIf an Excel number filter is not working, first check whether the cells contain real numbers or numbers stored as text; then…
- Excel MID Formula Not Working? Fix the Common CausesIf Excel’s MID formula is not working, first check that its arguments are in the right order: =MID(text,start_num,num_chars). MID starts counting at…
- Excel MID Function Not Working? Causes, Errors, and FixesIf Excel’s MID function is not working, check that its arguments are in the right order, the starting position is at least…
- Excel MAX Date Not Working? Fix Text Dates and ErrorsIf the cells contain real Excel dates, MAX returns the latest one: with dates in B2:B100, enter =MAX(B2:B100). For example, if the…
- Excel MAX Not Working? Common Causes, Checks, and FixesIf Excel MAX is not giving the result you expect, first check that the cells contain real numbers and that the formula…
- Excel MATCH Not Working? Fix Common Lookup ErrorsIf Excel MATCH is returning the wrong position or #N/A, first use exact-match mode by adding 0 as its third argument, then…
- Excel MATCH Not Working With Numbers? Causes and FixesExcel MATCH usually fails to find a number because the lookup value and the values in the search range are not the…
- Excel MATCH Function Not Working With Numbers? FixesIf Excel’s MATCH function cannot find a number, first check whether the lookup value and the numbers in the lookup range are…
- Excel MATCH Greater Than Not Working? Fixes That WorkExcel’s MATCH function does not treat a greater-than sign in its lookup value as a condition. For the first value strictly greater…
- Excel MATCH Not Working? Fix Common Lookup Errors FastIf Excel MATCH is not working, first force an exact match by setting the third argument to 0, then check that the…