Share via

Excel function - Advanced Filter

Anonymous
2024-08-22T09:57:02+00:00

Hi everyone,

I need to filter out a data set for information reflected under Reject Description column. I use advanced filter function but unable to capture the number information as shown in yellow highlite.

Can anyone advise what should I do in order to get what i want ?

Thank you, community members.

Microsoft 365 and Office | Excel | Other | Other

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

Rory Archibald 18,965 Reputation points Volunteer Moderator
2024-08-22T10:08:55+00:00

Use <> instead of * for the criteria. The * wildcard only works with text.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-23T00:32:48+00:00

    Hi Rory Archibald,

    Thank you for the answer. Your advice works.

    Was this answer helpful?

    0 comments