Results 1 to 4 of 4

[HELP] How do I create a list (Data Validation) and add to the list without cell reference

Threaded View

  1. #1
    Registered User
    Join Date
    05-17-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    19

    [HELP] How do I create a list (Data Validation) and add to the list without cell reference

    The data validation is a list, with this validation rule: "=$G$3:$I$3".

    How do I add "Seven" into it without using an extra cell at all?

    I was thinking of doing "=OR($G$3:$I$3, "SEVEN")" but that didn't work.

    And, another question, how do I add the "FOUR" if it is far away from the $G$3:$I$3 cells?

    Thanks! I've attached a sample so it is easier to understand.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1