Merge Multiple Cells/Rows/Columns Without LosingTesting to Determine IF a Filter is active by SpaceNorman on 62 Views 0 Likes 2 Replies DAX IF error the syntax is incorrect by bartvana on August 15How to correct this – Check the named ranges you have used and correct any misspelled names When you use a named range in the formula, you will notice that its color changes So in this case, you can spot any named range where the color is black, you may have found the culprit
How To Quickly Find And Remove All Rows With Errors In Excel