Hello dear freelancer, I'm looking to find someone, who can create an Excel sheet, that can do the following. If you think there is a better way to realize that instead of Excel, than of course I would be happy to accept.
The excel sheet contains a simple table of 2 rows and 24 lines with predefined numbers in each cell. (See attachment)
There should be a cell, that allows me to write whole numbers in. Another line should reflect the 24 most recent numbers that have been written in.
Everytime one of the number that has been write in that matches with one of the numbers in the table, the cell with the number should be highlighted with a predefined color.
The sheet should show the number of matched numbers for each row of the table and it should display the matched numbers of that row, that has the most numbers matched.
I what be happy to hear, if this is possible the code.
Much thanks in advance!