Re: This should be easy...

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

Jerry,

Here is a variation that caters for the -

=INDEX(B2:D2,1,MAX(IF(ISBLANK(B2:D2),0,IF(B2:D2="-",0,COLUMN(B2:D2)-1))))

I am not sure what you mean by the extra columns.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jerry" <nosoup4yew@xxxxxxxxx> wrote in message
news:1133455753.501219.289960@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Thanks for your reply. I could not get your solution to work for me
> though. Here's a little more info on what I'm looking to do:
>
> First, the equation I'm using with very limited success:
> =IF((AND(C3<>0,D3<>0,E3<>0)),E3,(IF(AND(C3<>0,D3<>0),D3,C3)))
>
> The spreadsheet setup:
> A B C D E
> 1 Est1 Est2 Act Total
> 2 Alpha 5.00 10.00 12.00 12.00
> 3 Beta 5.00 11.00 5.00
> 4 Gamma 10.00 11.00 -
> 5 Delta 10.00 -
>
>
>
>
> As you can see, the above equation only yields the correct Total in the
> Alpha row because all the fields have a value. In my actual
> spreadsheet there are 3 additional columns between the "Act" and "Rptd"
> that should not be counted in my equation, but if you use an array
> formula, would proabably have to be included. I'm not really familiar
> with arrays, so if you have any advice, I'd really appreciate it.
>


.

Relevant Pages

  • Re: Simple Array Looping
    ... > HTH ... > (remove nothere from the email address if mailing direct) ... >> having trouble figuring out how to loop through a list I define that will ... >> the next item in the array. ...
    (microsoft.public.excel.programming)
  • Re: Date Function
    ... Unfortunately, WEEKNUM will not return an array, don't know why, it is just ... HTH ... (remove nothere from the email address if mailing direct) ... > I've got the number of employes I used on that date next to the date in ...
    (microsoft.public.excel.worksheet.functions)
  • Re: SUMPRODUCT - How can I use does not equal in an array?
    ... HTH ... (remove nothere from the email address if mailing direct) ... > I am trying to say in an array "does not Equal". ...
    (microsoft.public.excel.worksheet.functions)
  • Re: get lowest positive number
    ... That is because you probably didn't array enter it. ... use Ctrl-Shift-Enter not just Enter to commit it. ... HTH ... (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.misc)
  • Re: Would it be worth making a dll for this?
    ... keys etc. ... > or is element a> element b) and writing values to a new array. ... > needed to unlock the .dll file. ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)