Re: Display Last Figure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try this formula

=INDEX(A1:A12,MAX(IF(A1:A12<>0,ROW(A1:A12))))

which is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

"EMoe" <EMoe.1wmyqd_1128863110.8686@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EMoe.1wmyqd_1128863110.8686@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hello Programmers,
>
> Example: I have a list of figures ranging from A1:A12. These cells
> contain formulas.
> If I have currency values in A1:A5, A:6 down to A:12 will have $0.00,
> because those cells haven't been updated yet.
>
> How do I display the last figure in the list in cell B1 (which in this
> case would be in A5); Without the $0's showing up as a value? Then as
> A6 updates, and it's the last value in the list, then that's whats
> shown in B1.
>
> Thanks,
> EMoe
>
>
> --
> EMoe
> ------------------------------------------------------------------------
> EMoe's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=23183
> View this thread: http://www.excelforum.com/showthread.php?threadid=474585
>


.

Relevant Pages

  • Re: get excel to automatically add fill color
    ... > some cells to be filled with color but they werent the right cells and ... > of conditional formatting but i just cant seem to hit on it.Bob Phillips ... >> Bob Phillips ... Now I want excel to ...
    (microsoft.public.excel.programming)
  • Re: Speeding up my Excel calculations.
    ... grouping dependent cells. ... Also, VLOOKUP can be a killer on large tables, so alternatives can often ... Bob Phillips ... Yesterday I learned that for complex worksheets, primary calculations ...
    (microsoft.public.excel.newusers)
  • Re: Speeding up my Excel calculations.
    ... I think I understand the concept, but as always I am having a hard time interpreting formulae. ... the VLOOKUP, which checks many cells is only invoked once, and then a much ... Bob Phillips wrote: ... set range, eg D7:D10000, for Sumproduct to search. ...
    (microsoft.public.excel.newusers)
  • Re: Conditional formatting
    ... I can't get it from Bob Phillips web site.the link seems to be broken ... Format "New" cells with green/bold then use the 3 CF conditions for the other 3 ... Conditional formatting only allows you to add 3 conditions. ... the code to the whole spreadsheet. ...
    (microsoft.public.excel.misc)
  • Re: Do You Miss Hearing About Cells All the Frickin Time???
    ... Programmers do not know they are hand-executing dataflow as they write all that code. ... Programmers have been doing it so long you cannot even point out to them that they are doing it. ... But until Cells/3 there was no data integrity and most things worked just fine. ... To avoid the performance penalty of forever worrying about synchronization I would relax integrity in |Cells| and then make synchronization an option which can be avoided by coding with a fuzzy integrity mindset, ie writing rules fully aware that data is arriving in different order and sometimes inconsistent with each other but eventually they'll converge so sure, launch that missile. ...
    (comp.lang.lisp)