Formula Works Only Sometimes???
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Thu, 14 Apr 2005 12:15:45 -0700
Hi!
I checked out your file but did so with macros disabled. I
don't trust ya!
Just a quick look over, your formula uses uneven ranges
and references:
=INDEX($Z$3:$Z$451,SMALL(IF($Y$2:$Y$451=$A$2,ROW
(A$2:A$451)),ROW(2:2)))
Are you specifically wanting to start with the 2nd value?
Is your formula generated by code?
Change to:
=INDEX($Z$2:$Z$451,SMALL(IF($Y$2:$Y$451=$A$2,ROW
(1:450)),ROW(1:1)))
You don't need code to do this.
Biff
>-----Original Message-----
>I have a formula that works sometimes, but not others.
>
>My example file can be found at
www.nmberger.com/example.xls.
>
>After you click the button (make sure cell A2 is
highlighted before you
>click the button or the formula won't work at all), you
select a project from
>the list box. Then the all values associated with that
project should appear
>in the next column over. It works with a lot of the
projects, but not all.
>Select 4008 or A1GQ, for instance, and you will get
values in return. Select
>F3MA, 6008, or 1020 and you get nothing. But if you
scroll over to columns Y
>and Z, you will see that there is values associated with
those projects.
>
>Any ideas???
>
>Thanks in advance.
>.
>
.
- References:
- Formula Works Only Sometimes???
- From: Nick
- Formula Works Only Sometimes???
- Prev by Date: Re: Miss-wrote previous "IF" problem
- Next by Date: Re: incrementing column symbols orthogonally?
- Previous by thread: Formula Works Only Sometimes???
- Next by thread: RE: Formula Works Only Sometimes???
- Index(es):
Relevant Pages
|