I’m having problems with a simple thing: I want to count all rows that contains values in just one specific column in my excel spreadsheet.
To understand better, imagine that my table is the example above.
| Column1 | Column2 | | zzz | example | | yyy | example | | xxx | |
If the robot counts all the rows with values in “Column1”, it will be 3.
If the robot counts all the rows with values in “Column2”, it will be 2
Can someone help me?