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.

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.
.

Sorry Nick,
But we NEVER download mystery files.
Sincerely,
Gary Brown

"Nick" wrote:

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.

I understand. Probably a good practice. The macro isn't important to my
problem anyways. It just takes distinct projects out of the list and returns
it to a cell.

"Gary Brown" wrote:

Sorry Nick,
But we NEVER download mystery files.
Sincerely,
Gary Brown

"Nick" wrote:

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.