On 2002-05-10 05:43, Skyhook wrote:
Colo,
That isn?t quite it. I have data in Column V7:V37. What I need is a formula in Column W7 that will get the data in the last cell in Column V. I don?t know if it will make a difference but Column V7:V37 contains formulas .
Thanks
On 2002-05-10 06:28, Skyhook wrote:
Yes. In Column V7 is S7+T7+U7. What i need is for column W to look for the last data in column V. If Column S7:U7 has no data then there will be a 0 in column V7. Hope this helps.
Thanks
On 2002-05-10 06:56, Skyhook wrote:
Aladin,
It is working but it is returning a 0 value. I tried hiding 0 values but this didnt work.
in column v7 is 22.0 In column v8 is 22.5 in coulmn v9:v37 is 0. I need the formula to ignore the 0's and return 22.5
Thanks
On 2002-05-10 08:40, Skyhook wrote:
Aladin
I tried the formula but it is still returning the 0 value. If you know of an easier way I am definitely up for suggestions
Thanks for all your help