1 of 1 people found this helpful
Good morning - there is probably more than one way to do this but see below
this first formula puts a 0 in the null values
the second counts the values greater than 0 and compares to 3 (ie number of years)
it will return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Awesome trick and many thanks Jim, learned something new today!
Glad to help out
Hi Kumar, thank you for the articles. Unfortunately I was unable to launch the workbook in the first article believed to a newer version. For the remaining articles, they seem to be talking able suppressing/hiding null values/indicators whereas my inquiry is more on suppressing the entire row if there is a null value in the column series.