Formula Filter does not pick up all rows

[Nawar Jameel]

Hello Team,

Can anyone help please about the below formula which does not pick up all rows and stopped at 3500k row.

{=IFERROR(UNIQUE(FILTER(Source_Data!$A$2:$A$49994,ISNUMBER(SEARCH($D$2,Source_Data!$A$2:$A$49994))*($D$2<>""),"")),"")}

I tried hardly to remove any bugs in the source column but no use.

By using drop down list, NOR is filtering 88 but in the source data the actual number is 343.

Should you need the excel file, please let me know.

Thank you.

 

[Fluff]

Thanks for that.
You have array entered the formula using Ctrl Shift Enter, which is why it only has88 rows & that is what you applied the formula to.
Select B5:B92 & delete the contents, then enter the formula in B5 only & do NOT use Ctrl Shift Enter.

 

[Nawar Jameel]

Thanks for that.
You have array entered the formula using Ctrl Shift Enter, which is why it only has88 rows & that is what you applied the formula to.
Select B5:B92 & delete the contents, then enter the formula in B5 only & do NOT use Ctrl Shift Enter.

You are a diamond mate
It works brilliant
Thank you

 

[Fluff]

Glad we could help & thanks for the feedback.

Also please update your profile as requested.