bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
hello
is it possible to limit the formula to not go beyond row 75 on the "Data" worksheet?
=IF(ISTEXT(INDIRECT("Data!C" & (12+ROWS($1:1))-1)),INDIRECT("Data!C" & (12+ROWS($1:1))-1),NA())
im saying bc, on my data sheet row 76 is a legend marking, and this formula, if i delete a row i.e. a employee name,...it shows the legend into the calculation row.
thxs alot again!
is it possible to limit the formula to not go beyond row 75 on the "Data" worksheet?
=IF(ISTEXT(INDIRECT("Data!C" & (12+ROWS($1:1))-1)),INDIRECT("Data!C" & (12+ROWS($1:1))-1),NA())
im saying bc, on my data sheet row 76 is a legend marking, and this formula, if i delete a row i.e. a employee name,...it shows the legend into the calculation row.
thxs alot again!
