Forum Discussion
Solved
COUNTIFS with unique values
Hello all Would appreciate some assistance with this one please. I've been messing around with variations of SUMPRODUCTs and such on this one but just can't nail it down. All I need is for th...
=SUM(N(IF(($C$3:$C$22<>"")*($E$3:$E$22=I8),MATCH(IF(($C$3:$C$22<>"")*($E$3:$E$22=I8),$C$3:$C$22),IF(($C$3:$C$22<>"")*($E$3:$E$22=I8),$C$3:$C$22),0)=ROW($1:$20))))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. If you work with Office 365 or Excel 2021 you can use the FILTER and UNIQUE functions which significantly simplify the task.
=SUM(N(IF(($C$3:$C$22<>"")*($E$3:$E$22=I8),MATCH(IF(($C$3:$C$22<>"")*($E$3:$E$22=I8),$C$3:$C$22),IF(($C$3:$C$22<>"")*($E$3:$E$22=I8),$C$3:$C$22),0)=ROW($1:$20))))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. If you work with Office 365 or Excel 2021 you can use the FILTER and UNIQUE functions which significantly simplify the task.
Hi Quad, this was very helpful. Much trickier than I was expecting!
Thank You!
Thank You!