Hi Guys, I'm stumped with this one. I'm using the following formula in column E to return the row numbers of the name I've selected in column A. It works fine for a small array of 1000 rows, but when I increase it to 10,000 for example.... it returns BLANK? - Any Ideas?
=IFERROR(SMALL($Q$2:$Q$1048,ROWS($Q$2:Q2)),"")
[TABLE="width: 454"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD] D[/TD]
[TD] E[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD="align: right"]56[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD="align: right"]57[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD="align: right"]58[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD="align: right"]59[/TD]
[/TR]
[TR]
[TD]Michael Davies[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]Michael Davies[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD="align: right"]145[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]
=IFERROR(SMALL($Q$2:$Q$1048,ROWS($Q$2:Q2)),"")
[TABLE="width: 454"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD] D[/TD]
[TD] E[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Adrian Owens[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD="align: right"]56[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD="align: right"]57[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD="align: right"]58[/TD]
[/TR]
[TR]
[TD]Thomas Lewis[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD="align: right"]59[/TD]
[/TR]
[TR]
[TD]Michael Davies[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]Michael Davies[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD="align: right"]145[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]