Looping a Code


    Hi everyone,

    What I'd like is a list down column A of: cat written 3 times, dog 10 times, horse once, octopus 7 times and no cows - I'd like it to ignore 0s. From what I've googled I figured it must involve looping but I can't figure out how to go about it simply. Thanks

  • Re: Looping a Code

    Hi allensow,

    Welcome to Ozgrid!!

    Here's one way:



  • Re: Looping a Code

    And another...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!