Excel Filter Function Multiple Criteria

General Excel Questions & Answers

2 Posts

2 Users

0 Reactions

77 Views

RSS

Robert Rafferty

(@raffrobb)

Posts: 38

Trusted Member

Topic starter

Hi All
I am unable to filter on 2 criteria/conditons using this Filter function.

=FILTER(Combo,Combo[Period Number]=1)*(Combo,Combo[Location Number]=105)

I am getting errors, and can't figure out why

Posted : 07/10/2020 1:48 am

Mynda Treacy

(@mynda)

Posts: 4761

Member Admin

Hi Robert,

Try =FILTER(Combo,(Combo[Period Number]=1)*(Combo[Location Number]=105))

Mynda

Posted : 07/10/2020 6:12 am

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed