Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    14
    ReputationRep:
    https://docs.google.com/spreadsheets...it?usp=sharing


    Basically, I have column A with Box Names and column B with numbers. On another sheet, I need to pull out the Box Names with 13 as their number. It needs to be a condensed list, so the first however many cells in the other sheet should be the names of the Boxes with 13 as their numbers, and the list should update whenever a Box loses or gains a number to make it something other than 13.


    Thanks!
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Would you rather give up salt or pepper?
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Write a reply...
    Reply
    Hide
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.