Hello and welcome to our community! Is this your first visit?
Register
Results 1 to 4 of 4

Thread: Excel Help

  1. #1
    Veteran Enthusiast
    Join Date
    May 2006
    Location
    Midlands, UK
    Posts
    5,638

    Excel Help

    Hi guys, does anyone know a formula that will stop a value being repeated if it was entered into a previous cell of the same column?

  2. #2
    Obsessed Veteran Adam's Avatar



    Join Date
    Nov 2004
    Location
    UK / England
    Posts
    17,271

    Re: Excel Help

    My friend just made this for you.

    downloads/Listcheck.xlsx

    Hope you find it useful in one way or another.

  3. #3
    Veteran Enthusiast
    Join Date
    May 2006
    Location
    Midlands, UK
    Posts
    5,638

    Re: Excel Help

    Cheers Adam, same to your mate too!

    In my exam I decided to test my luck with some custom data validation, looking at what your mate did, it wasn't as complex but I hope it got some marks.

  4. #4
    Obsessed Veteran Adam's Avatar



    Join Date
    Nov 2004
    Location
    UK / England
    Posts
    17,271

    Re: Excel Help

    No problem.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •