I have a worksheet with 6 groups, I have included an excerpt with 2. The data has years 1 - 10.
*slope92 and mean92 use values from years 1 -5
*slope01 and mean01 use values from years 6 -10
The data has missing values indicated by blanks:
1.) I need the "slope" values to be "-9999" if there are any missing values (blanks) in the row.
2.) I need the "mean" values to be "-9999" if there are more than 2 missing values (blanks) in the row.
Can this be done with a macro or formula? Annotation appreciated.
Thank you kindly,