Mel C Roberts
New Member
- Joined
- Feb 26, 2002
- Messages
- 40
Hi,
Can anyone help.
I have a table that copies from a pivot table and hence the data location can change dependent upon the pivot table criteria.
What i need is a formula that will search one column to find the statement "Total" (say it is in B7) and then return a formula in the same row but in a different column ie E7.
I have done it this way to enable me to change the sum function which is determined by the majority of my data. The formula i need to return in the said cell is C7/D7 for the example above.
Obviously the next time i refresh the chart the "total" cell could have moved hence the need for some VB or a Lookup?
Thanks heaps.
Mel x
Can anyone help.
I have a table that copies from a pivot table and hence the data location can change dependent upon the pivot table criteria.
What i need is a formula that will search one column to find the statement "Total" (say it is in B7) and then return a formula in the same row but in a different column ie E7.
I have done it this way to enable me to change the sum function which is determined by the majority of my data. The formula i need to return in the said cell is C7/D7 for the example above.
Obviously the next time i refresh the chart the "total" cell could have moved hence the need for some VB or a Lookup?
Thanks heaps.
Mel x