I have 16 different datasets and 112 different variables in each dataset but I would like to know if there is any function to check if the variables match in each dataset.
I have the variables copied into a new spreadsheet row wise on top of each other. Can someone please tell me a code that would print a "*" next to each cell that does not match up with the call above/below it.
New to excel so apologies in advance if this does not make sense.
