Re: can it be done without vb




Cheers for this, works a treat. I see where I was going wrong. My
thinking was that I had to address the whole matrix, not just the
values as is the case.


Many thanks, all very clear how this works. Easy when you know how.
:cool:

It was really bugging me but I was addressing the whole matrix, titles
and values.

Many thanks again i can now do the calcs i wanted, will save a lot of
time too.

Regards
Bob :)


--
spikk
------------------------------------------------------------------------
spikk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24932
View this thread: http://www.excelforum.com/showthread.php?threadid=384691

.



Relevant Pages

  • Re: plz help
    ... Best regards. ... hideki's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18903 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Vlookup
    ... You helped me score some major brownie points with my boss!!! ... Best regards, ... akaramarkovic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24801 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Hide/Unhide Rows
    ... Regards, ... Amber:) ... Amber_D_Laws's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30012 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Unicycling shoes
    ... Chrashing - Unicycles are flying machines! ... Regards, ... Chrashing's Profile: http://www.unicyclist.com/profile/7501 ... Prev by Date: ...
    (rec.sport.unicycling)
  • Re: Left() or Right()
    ... > and the space was properly displayed between 2 dbl quotes. ... >> Regards. ... >> BenjieLop ... >> BenjieLop's Profile: ...
    (microsoft.public.excel.misc)