Looking for VBA to check if all data in a column is the same (text) -
For example - if I did it manually -top row cell 1 would contain" '=IF(AND(B1=B2,B2=B3,B3=B4,B4=B5,B5=B6,B6=B7,B7=B8,B8=B9),TRUE,FALSE)
But ideally I need this to just loop thru and check that all cols contain same text - for entire range (lets say 300 columns maybe).
Example data set - and somehow column C would get flagged with a difference (pop up OR text somewhere):
A B C
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have seen several suggestions for how to do this with numbers, some at a row level -but not text within a column in same sheet.
History = I have 5 sheets or so in a workbook - I want to check that the header row for EACH sheet is all the same. So I just grabbed those headers to a new cheat similar to above..
Thanks in advance.
For example - if I did it manually -top row cell 1 would contain" '=IF(AND(B1=B2,B2=B3,B3=B4,B4=B5,B5=B6,B6=B7,B7=B8,B8=B9),TRUE,FALSE)
But ideally I need this to just loop thru and check that all cols contain same text - for entire range (lets say 300 columns maybe).
Example data set - and somehow column C would get flagged with a difference (pop up OR text somewhere):
A B C
cat | dog | ball |
cat | dog | ball |
cat | dog | bat |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have seen several suggestions for how to do this with numbers, some at a row level -but not text within a column in same sheet.
History = I have 5 sheets or so in a workbook - I want to check that the header row for EACH sheet is all the same. So I just grabbed those headers to a new cheat similar to above..
Thanks in advance.