Filter formula change in days

[Pibsandsquibs]

Hi

I have a spreadsheet where one column shows changes in number of days of the date the order is expected to arrive. So yesterday it could have said the arrival date was 01/10/24 but today it is saying 29/09/24 so has come forward 2 days and the changes in number of days is -2.

As this spreadsheet looks at all the orders is there a formula to filter out all the changes in days whether they are -3, -2, -1, 1, 2, 3 (obviously could be more but you get the idea). So I want something that excludes all the orders where the date hasn't changed. i.e 0.

I am using the formula to get everything that is a positive change, but can't workout how to combine to include the changes that are -1, -2,-3.

=FILTER(A2:P7,P2:P7>=1)

 

[RobP]

Hi,

for multiple criteria you use the asterisk * between them and bracket each like thus :

=FILTER(A2:P7,(P2:P7>=1)*(P2:P7<>0))

Hope that helps
Rob

 

[felixstraube]

If you want to exclude the rows where there was no daily change (that is column P = 0) try:

=FILTER(A2:P7,P2:P7<>0)

 

[Phuoc]

Try this:

=FILTER(A2:P7,ABS(P2:P7)>=1)