-1

How can I identify duplicate consecutive cells, not in adjacent columns but adjacent rows like my sample below: In the same scenario mentioned above I need to know only if there would be the same string of characters in 2 consecutive cells and that I need to know how many times they are repetitive in 2 or more consecutive cells.... Remember conditional formatting does not help. I need the count

Improve this question
2
  • 1
    Sample seems to be lost. Edit and add.
    – Akina
    Commented Sep 25, 2019 at 13:55
  • Could you provide a sample about this problem? You can upload a screenshot or sample file.
    – Lee
    Commented Sep 26, 2019 at 8:44

1 Answer 1

Reset to default
0

A start is the make a new column with the following function for data in column A:

=COUNTIF(A2:A3,A2)

This will count how many times the string in cell B1 is found in cell B1 and B2. So if there is a consecutive duplicate, it would show the number 2.

Improve this answer
2
  • Since the OP mentioned rows the range would be more like A2:B2
    – gns100
    Commented Sep 25, 2019 at 16:40
  • This only helps if there are only two columns to test. Doesn't sound like that's the case..
    – Alex M
    Commented Sep 25, 2019 at 20:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .