Hi all,
I have a excel sheet with range A1:Y18
I have to check if the empty cells is present in column R,S,T
And write the count in the next cell Z.
Any idea how to achieve this?
Thanks in advance.
Hi all,
I have a excel sheet with range A1:Y18
I have to check if the empty cells is present in column R,S,T
And write the count in the next cell Z.
Any idea how to achieve this?
Thanks in advance.
There are multiple ways to do it.
Easiest is to read the excel sheet into the DataTable
Loop through it
Set counter = 0
check
if row(“R”) or row(“S”) or row(“T”) is null or empty using a series of if statement for each condition.
If each cell is empty, then add 1 to counter
Then write it row(“Z”) = counter
Hi @Ray_Sha1 !
Here is a suggestion: count_empty_cells.xaml (9.2 KB)
Don’t forget to modify your read and write range.
Also, let me explain some elements:
Hey, thank you y’ll
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.