I have a consolidated table with five columns with amounts for the years 2013, 2014, 2015, 2016 and 2017. (Column name = 2013, 2014 i.e.).
I would like to remove all rows in my table where ALL cells for this five columns are empty/null. How to???
I have a consolidated table with five columns with amounts for the years 2013, 2014, 2015, 2016 and 2017. (Column name = 2013, 2014 i.e.).
I would like to remove all rows in my table where ALL cells for this five columns are empty/null. How to???
Create a new column using "if" and "and" like this....
= if [2013]=null and [2014]=null and [2015]=null and [2016]=null and [2017]=null then "Delete Me" else "Keep Me"
Use this new column and filter out the "Delete Me" rows.
Note the "if", "then", and "else" need to be in lower case letters.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks