200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
hi
i want to make a formula for an excel sheet that would count how many cell in a selection are not empty and does not match teir cell to the left. i would also need a formulas that would do the same but count it if it does not match the cell that is 2 cell to the left
Please try this array formula.
=SUMPRODUCT((COUNTIF($E3:$E11,$D3:$D11)=0)*($E3:$E11<>""))E3:E11 is the criteria range, D3:D11 is the one to the left of it. C3:C11 would be two columns to the left.
This is an array formula which must be confirmed with Ctl+Shift+Enter. If correctly confirmed it will appear between curly braces in the formula bar.