Missing Data
Closed
def
-
Dec 5, 2011 at 12:33 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2011 at 04:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2011 at 04:40 PM
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
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
Related:
- Missing Data
- Tmobile data check - Guide
- App store icon missing - Guide
- Word scroll bar missing - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Missing image icon - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 5, 2011 at 01:39 PM
Dec 5, 2011 at 01:39 PM
If you filter your sheet for blanks, wont you get what you seek?
Dec 5, 2011 at 03:40 PM
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
Dec 5, 2011 at 03:41 PM
Dec 5, 2011 at 04:40 PM
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