Hello, working with a large sheet and need to copy down
=COUNTIFS(N:N,N2,H:H,H2)
,however, excel bombs out on me. In reading through various forums, using a formula like
=SUM(--(FREQUENCY(IF(c1,IF(c2,MATCH(vals,vals,0))),ROW(vals)-ROW(vals.1st)+1)>0))
may take less computing.
1) is this the correct formula to replace my countifs ?
2) if so, how do I fill in the SUM FREQUENCY MATCH formula? I've tried numerous scenarios and get errors.
Thank you so much for the help.