G’Morning Ladies & Gents,
Don’t really like to bother you, I only do so after I’ve tried several times to get a formula to work…
Not having much luck with my current problem..
Before I give up altogether I thought I would “Ask for help from an Expert”..
In my “spreadsheet A”, I have a formula in a cell in column G =Index(B:B,Count(B:B)) that picks up the last figure in column B, that has been working well for years..
Now I’m trying to get that same “last Figure” from spreadsheet A into my new “spreadsheet D”.
I’ve tried formulas like =Index(B:B,Count(B:B)) & various =(IF & =IF(AND combinations, so far all I get is the standard Error window, with varying messages about Broken Formulas etc
I feel the problem lies in linking one spreadsheet cell to a second spreadsheet cell, then trying add the =INDEX(Count formula.
If anyone has the time to spare I REALLY would appreciate some help.
Don’t really like to bother you, I only do so after I’ve tried several times to get a formula to work…
Not having much luck with my current problem..
Before I give up altogether I thought I would “Ask for help from an Expert”..
In my “spreadsheet A”, I have a formula in a cell in column G =Index(B:B,Count(B:B)) that picks up the last figure in column B, that has been working well for years..
Now I’m trying to get that same “last Figure” from spreadsheet A into my new “spreadsheet D”.
I’ve tried formulas like =Index(B:B,Count(B:B)) & various =(IF & =IF(AND combinations, so far all I get is the standard Error window, with varying messages about Broken Formulas etc
I feel the problem lies in linking one spreadsheet cell to a second spreadsheet cell, then trying add the =INDEX(Count formula.
If anyone has the time to spare I REALLY would appreciate some help.