Hello People.
I am conducting experiments in the real world with spices for a chicken rub.
I would like to write out a spreadsheet that checks to see if I have done the particular formula before so that I don't waste my time cooking chicken wings that I have already tried.
Here is a copy of my sheet,
formula_checker.xlsx
I have represented each herb and spice with letters instead but as you can see from the spreadsheet I have in recipe number 1, 1qty of A, 0.5qty of B, etc etc.
What I want to do, is that the cells in column L, check to see if any of the rows of figures are the same as any other of the rows, and if so, highlight it in red for example. See here how cell L6 is RED, because the row 6 is the same as row 2 (cells B2 to K2) and (cells B5 to K5) are identical.
Please can someone tell me what the formula should be in my column L? To do what I require?
Bookmarks