Missing Data

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

i have a list of dates from 1956 to 2006 for precipitation recordings, i want to identify which dates have no data input, btw there are days when there is a 0 for rainfall i just want to identify when there is no recording (cell is blank)

Thank you



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
If you filter your sheet for blanks, wont you get what you seek?
ok i have one:

Col1: Dates
Col2: Data

if i selected eanywhere it say filter, i try with value but doesnt work

how do i do this again? thank you
i just noticed there are no spaces lol... then id have to do the filter from the dates column...
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am not sure if you got the answer or not.

In case you did not, what I was trying to say was that lets say you have two columns as you said.
If all I want is show me rows that have date but no data, then I would filter the sheet and filter the data column for blanks and date column for non-blanks