Thank you Decio! Much better your way!
You both helped a lot, but... every time I work this spreadsheet, something new happens.
Now I'm having a problem with the data validation. Since I cant repeat a number in the same line I created a Data Validation that doesn't allow this and immediately...
Attached is the file.
Each individual line can't repeat one number already in the same line, but other line can repeat the number in another line and even repeat the entire line. What I need now is to check in the entire range (now it is from B5 to P34) what are the most commons numbers...
Thank you, that worked fine!
Another doubt, I also need to find the 1st, 2nd, 3rd...and 15th more occorring number in the range.
Could you help please?
Thanks a lot!
I have numbers in a range from B5 to P35 which I need to color them everytime they match to the ones in B2 to P2. Each number in the range of B5 to P35 need be colored if it matches one number in the line B2 to P2.
Help, please.