Repetition

I have four columns where each cell in these columns have numbers.
I would like to know which lines have the same numbers, and which line is the line that repeats, and how many reps I have in four columns.

see Attachment

so are you saying that you are ONLY looking to find instances where all cells in a row match?...row 2, row 6 and row 11?

yes!!
thank you!!

im still working on how to put all instances of a match in F2, but i added the following to a helper column in E to give me row numbers. you could use this with a filter to find your matches...

=IF(SUM(A2:D2)/COUNT(A2:D2)=D2,D2&" @ Row "&ROW(),"")

Modify this if you want, it returns an answer that gives you..."1 @ Row 2"

I found very interesting but I do not know how to continue.

Você consegue fazer isso pelo VBA.

Acho que eu não informei direito.

os números da linha A1:D1 tem que ser igual a outras linhas.

os números precisam estar na mesma ordem.



linha 1.....1-2-3-2 This*line 1*is repeated*and 3

linha 2.....2-2-3-1

linha 3.....1-2-3-2 This*line 1*is repeated*and 3

linha 4.....6-1-3-2

linha 5.....5-2-3-2

linha 5.....1-6-3-2

ok try the attached. If you need to move stuff around, make sure you adjust the references in the indirect() part of the calcs. you can hide what you dont need to be seen...

something is not right.
try to put these numbers in line 6

2 3 4 5
then in row 3 and 6 should the line shown in their formula

ok i did...and it worked fine. gave 2 rows of duplicates...row 2 and row 11

you said it needs to check ONLY if all numbers in that row were the same, thats what it does

jindon, I downloaded attachment, was very good, thank you very much!

Thank you all