Ask Your Question

Revision history [back]

Counting duplicate numbers in various rows on a sheet

Hello. This question has been answered in various ways, but not in ways that suit my application. An example screen shot is attached. I want to count duplicate occurrences of any number row-by-row on a sheet. The formula in a separate column ("Duplicates") is highlighted if it exceeds three numbers duplicated in any other row, as shown on rows 4 and 11. The raw data columns/rows don't need to be highlighted; I just did that for clarity. I will highlight the duplicates column with a rule; all I need is a formula for the column. Thanks huge for any help provided! C:\fakepath\LibreOffice Question.png

Counting duplicate numbers in various rows on a sheet

Hello. This question has been answered in various ways, but not in ways that suit my application. An example screen shot is attached. I want to count duplicate occurrences of any number set of numbers row-by-row on a sheet. The formula in a separate column ("Duplicates") is highlighted if it exceeds three numbers duplicated in any other row, as shown on rows 4 and 11. The raw data columns/rows don't need to be highlighted; I just did that for clarity. I will highlight the duplicates column with a rule; all I need is a formula for the column. Thanks huge for any help provided! C:\fakepath\LibreOffice Question.png