Question Validating Cell if there is same info

gtr232

New member
Joined
Jan 29, 2016
Messages
1
Programming Experience
Beginner
Hello guys I have 1 question How Can i check cell if there is same Data or not . For Example Untitled.png here you see that there are many 2550000 so i want to code that checks this row and see if there is more than 4 same info just MessageBox.Show("there are too many same data"+(the data what is too many));
plz if you can help me out of this solution thnx anyway
 
The simple option is to just loop through the rows and count. For each row, get the cell value from that column and compare it to the value of interest. If they match, increment a counter. At the end of the loop, check whether the counter is over a threshold.
 
Back
Top Bottom