Filter function

[Sarah7828]

Hi

I am trying to use the filter function to extract data

I have the following column titles I want to bring across

Acctid , transaction ….premium account , difference

In the difference column is my criteria such as -0.01 , 0.01

My formula ( on a new worksheet)

Cell A2= - 0.01

=filter(acctid to difference, difference =A2,””)

The formula only returns on row when there are more than that

Could you let me know what I am doing wrong in the formula

Thank you

 

[myall_blues]

That's not your literal formula is it?

If A2 and your filter formula are on a separate worksheet to the data sheet where the columns of interest are, then you need to precede the references by the sheet name. So for example if your columns acctid etc are in A2:E30 on Sheet1 then:

=FILTER(Sheet1!A2:E30,Sheet1!E2:E30=$A$2,"")

 

[Sarah7828]

Hi myall that is what I have done , but only one row for that criteria , for example , 0.01 comes across

 

[Sarah7828]

Or should I have put the filter formula on the same worksheet as the orginal data?

 

[Phuoc]

Try this:

=filter(acctid to difference, ABS(difference -A2)<=0.01,””)