Sorry, I did not express clear enough.
There are 3 steps inside For each row in dt
- Check Column “Status” at row(5)
If String.IsNullOrEmpty(row(5).ToString) is TRUE
- Check Column “username” at row(1) whether it is duplicated or not
Assign ListDup = dt.AsEnumerable().Select(function(x) x.Field(of String)(“Site Address”)).GroupBy(function(x) x).Where(function(g) g.Count() > 1).ToList().Count
If ListDup = 0 is TRUE (not duplicated)
- Want to Write Cell to make Column “Status” for this row to be “Not NullOrEmpty”, means job done.
Yes, @likith_rajesh now I know the mistake, but how can i assign a variable = the CellAddress. There are many index or cell in Browse for types, which variable type should I choose?
@Palaniyappan If String.IsNullOrEmpty(row(5).ToString) is False, means job is done, will do nothing in Else. Am I right in this design logic?