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

Help
, ,
1

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

2

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.

3

Read data using read range ----------Say DT
Then Use
DT.DefaultView.ToTable(True,“ColumnName”).Rows.Count
If rows count is 1 that means there are same values in that column

image
image

4

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