I have a column of over 200 rows. I would like to identify all the cell locations within that column that have the value of “0”. I know the address function can be used on a single cell, but I would like to create a list of all the cell addresses with this value. Is this possible?
Any help would be appreciated.