hello,I can count repeated values for each row, repeated that match only previous rows line by line:
=SUMPRODUCT(COUNTIF($A1:$F1,A2:F2))
But wondering if I can count them all in a range together?
Thank you screenshot.2154.jpg
hello,I can count repeated values for each row, repeated that match only previous rows line by line:
=SUMPRODUCT(COUNTIF($A1:$F1,A2:F2))
But wondering if I can count them all in a range together?
Thank you screenshot.2154.jpg
Last edited by Excl3454; 02-17-2022 at 11:52 PM. Reason: done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks