Forum Discussion

Eliecer's avatar
Eliecer
Copper Contributor
Jul 31, 2022

Filter Function error

Hello,  
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 31, 2022

Hi Eliecer 

 

It's highly probable that values in A6 and D6 don't compare (i.e. extra space(s) in one of them). To check, in an empty cell enter =D6=A6

If you get FALSE this confirms the values don't compare. If you get TRUE then please share your sample workbook & explain where the data in D2:E6 come from (i.e. copy/paste from a Web page)

  • Eliecer's avatar
    Eliecer
    Copper Contributor
    Jul 31, 2022
    Hi L z., I compared and the result is true,. The data is coming from a huge Excel data base and I just extracted a sample of the issue. I attached the file for testing.
    Thank you!

Resources