offset....

[jw01]

hello

i was wondering if it's possible to apply offset/counta to my possible if(istext formula.

basically, i have a graph which shows by largest to smallest, how much revenue a certain employee is making.

i have the offset function in my graph to make it dynamic, however in the "calculation" worksheet, C68:C161 ie.
=IF(ISTEXT(Data!C36),Data!C36,NA())
the calculation worksheet will be hidden, so the issue im having is

if u go to worksheet 'data', and remove i.e. the row i have highlighted in 'Red', the order in worksheet column C, does not readjustment, so it shows N/A# error on the graph.

can someone pls help with this issue; ive been staring at my screen! pls and thx u so much!!!!

i have lighted in yellow, column c. again, pls note calclation is a hidden worksheet when it will be used by a branch.

[tigertiger]

This error is that because of #REF reference as the row is deleted
To solve the problem:
+ You change the formula at C68 in sheet Calculation to :
=IF(ISTEXT(INDIRECT("Data!C" & (12+ROWS($1:1))-1)),INDIRECT("Data!C" & (12+ROWS($1:1))-1),NA())

Where 12 is the row that the data start (c12 in sheet Data)

+ and Copy fill down to C69,C70,.....

[arthurbr]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

[jw01]

thxs guys and sorry!