Match number on any part of above adjacent row.

Hello all,
Not sure if this is a function or macro question. Experts will decide.

In cols I to O I have numbers only, cols V to P will answer result True only.
All of the numbers that are highlited red are true if they match the same number only on the above adjacent row. Anywhere on that row.

Example #1, cell I3 number 5 matches cell O2.
Example #2, cell M4 number 5 matches cell J3.
etc, etc.

Hope this is a simple request.
Thanks.

=if(isnumber(match(i3,$i2:$o2,0)),true,"")

Fromula for the TRUE's and empty cells (if false): Please try in P3 and copy to the rigt and down:

Formula:

Please Login or Register  to view this content.

Formula for the red numbers, please try CF-rule applies to =$I$3:$P$14:

Formula:

Please Login or Register  to view this content.

Big thanks to everyone.
I have put all the functions into this one sheet so everyone can view them.

All great results. Solved.
Thanks.

Thanks for sharing the sheet with all solutions.

You are Welcome!

Thanks for your feedback and rep . Glad to have helped.