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]

What happens if you use

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

 

[Nawar Jameel]

What happens if you use

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

Hello Fluff,

Thanks for your suggestion.

Unfortunately, it did not work out.

Same amount (88) and with duplications.

If you can give more suggestions that would be very helpful.

Much appreciated.

 

[RoryA]

Can you please update your profile to reflect the version you are actually using (it's obviously not 2013)?

It might be useful if you can post a link to your workbook.

 

[Nawar Jameel]

Can you please update your profile to reflect the version you are actually using (it's obviously not 2013)?

It might be useful if you can post a link to your workbook.

I'm using Microsoft 365

Apologies I don't know how to link my workbook

 

[RoryA]

Please update your profile settings then.

You would have to upload it to a sharing site like OneDrive or Dropbox and then post a public link here.

 

[Nawar Jameel]

Please update your profile settings then.

You would have to upload it to a sharing site like OneDrive or Dropbox and then post a public link here.

This is the link of my file:

https://drive.google.com/file/d/10qLIQRWl-zj6TpuhHUpmWzYU16rviNN5/view?usp=drive_link

Many thanks

 

[RoryA]

It needs to be a public link please

 

[Nawar Jameel]

It needs to be a public link please

Apologies for the mishap.

This is a public link via We Transfer:

Draft Reg..xlsb

Link will expire after 1 week please.

Hoping meets your requirements.

Thanks.

 

[Nawar Jameel]

Apologies for the mishap.

This is a public link via We Transfer:

Draft Reg..xlsb

Link will expire after 1 week please.

Draft Reg..xlsb

drive.google.com

Google drive link is also public

Hoping meets your requirements.


Thanks.