Check if all the cells in a column have the same value

I need to check if all cells in a column have the same value, how best to do that?

try to take distinct values for that and if all cells in that column are same value means you will get count 1 other wise you will get more.

Read data using read range ----------Say DT
Then Use
If rows count is 1 that means there are same values in that column


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.