hello, in the attached file there are numbers and in some lines there may be 2 equal numbers.
I am interested only in the case that, if there are 2 equal numbers in a row, the corresponding content of row I4: R4 is reported in G5: H14.
Thank you
hello, in the attached file there are numbers and in some lines there may be 2 equal numbers.
I am interested only in the case that, if there are 2 equal numbers in a row, the corresponding content of row I4: R4 is reported in G5: H14.
Thank you
Try below formula in G5, copy and paste across
=IFERROR(INDEX($4:$4,AGGREGATE(15,6,COLUMN($I5:$R5)/($I5:$R5=MODE($I5:$R5)),COLUMNS($G5:G5))),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
hello, perfect works
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks