I have a number of columns that contain a letter and I want to be able to check if all letters of "selected" columns match. I'm using an indicator in row 2 with either a '1' or '0' to indicate whether the column is selected.
I know the Exact function will return a True or False for comparing cells of strings, but I only want to compare the cells that are in selected columns. Is there a way I can do this?
I know the Exact function will return a True or False for comparing cells of strings, but I only want to compare the cells that are in selected columns. Is there a way I can do this?