B
Biff
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
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