I'm looking to create an Excel sheet, to anylize and visualizy simple strings of numbers.
The excel sheet should contain 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 put in strings of numbers.
Another field should reflect the 24 most recent numbers that have been written in.
Everytime one of the typed numbers matches with one of the numbers in the table, the particular cell should be highlighted with a predefined color.
Finally there should be a column that counts the number of matches for each table and it should display the matched numbers of that row, that has the most unmatched numbers. I also require a function to reset all typed in numbers
Much thanks in advance!