Share via

Formula to remove zero's in =Filter

Anonymous
2022-04-17T17:53:58+00:00

I need a formula that will remove the zero's as in (Pic 1)

Microsoft 365 and Office | Excel | For home | 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

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2022-04-17T18:59:45+00:00

    From which column(s) do you want to remove zeros?

    0 comments
  2. Anonymous
    2022-04-18T04:28:08+00:00

    I assume you can have more than one scorer in each period. True?

    .

    bit of a challenge since player numbers include 0's.

    0 comments
  3. Anonymous
    2022-04-18T09:36:04+00:00

    Hans P1,P2,P3,P4,P5,P6,& P7. Where the zero's appear shuould appear as below. As you can see when I use =""& it returns the dates as in this screenshot. blank.

    17 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-04-18T09:40:55+00:00

    Rohnski2 the G = goals which hopefully you are aware the are allowed to do! Where you see 0 should be blank.

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2022-04-18T09:58:44+00:00

    another option is select the columns you want to get rid of zeros, X to AD

    apply conditional formatting if cell = 0, apply the formatting white text, white fill to hide the zeros

    0 comments