79549278
Date: 2025-04-01 22:11:08
Score: 1.5
Natty:
=SUM(N(MMULT(N($B$2:$G$13=J2),ROW($1:$6)^0)*MMULT(N($B$2:$G$13=K2),ROW($1:$6)^0)>0))
With legacy Excel such as Excel 2013 you can apply this formula which has to be entered with ctrl+shift+enter as an arrayformula if you don't work with Excel for the web or Office365.
Reasons:
Posted by: user22566114 - Probably link only (1):
- Low length (0.5):
- Has code block (-0.5):
- Low reputation (0.5):