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)

Resources