Share via

Filter Formula to list values that match a greater or less than criteria.

Anonymous
2023-03-10T18:28:46+00:00

I need to make three separate lists of values from column B per the criteria from cells F1 and G1 and columns C, D, & E.

The criteria is if the value in column C, D, or E is greater than the value in cell F1 or less than the value in cell G1 than provide a list of names that meet that criteria.

I have manually typed the correct answers in columns I - K.

I cannot add multiple columns that help the filter. For example, I cannot create a new column that says =IF(or(C1>$F$1,C1<$G$1),"x","") and then use the filter formula to write = Filter(B2:B12,New Column Array = "x")

I have tried =Filter(B2:B12,(C2:C12>F1)*(C2:C12<G1)) but this does not work.

Thanks in advance for your help!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2023-03-10T18:36:03+00:00

Use "+" instead of "*"

=FILTER(B2:B12,(C2:C12>F1)+(C2:C12<G1))

Was this answer helpful?

5 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2023-03-10T18:45:35+00:00

    Thank you!

    Was this answer helpful?

    0 comments