LinkBack URL
About LinkBacks
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
Hi,
the "2" is also repeating in your range and you didnt color this one....
Is this s a mistake or perhaps I didn't understand your question?
sorry I dont mean counting all duplicated,, just counting duplicates that are appears in Only previous row. ThanksOriginally Posted by belinda200
Try, for row 3:copied down.Formula:
=SUM(COUNTIF(A2:F2,A3:F3))
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If I understand you correct and the answer should be "8", then this formula can help here:
=SUM(--((FREQUENCY(A2:F6,A2:F6)>1)))
thanks,,but the answer is 6,I counted for each row Q2:Q6 . question is i just need to count duplicated that are from previous row. thank you
If it's a total of the repeats for each row, the answer is 6.
=SUM(COUNTIF(A2:F2,A3:F3))
counts every row for matches in a row before, so can count them line by line, is possible to count numbers of repeated values in whole range that are repeated only one row above them with one formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks