+ Reply to Thread
Results 1 to 10 of 10

Data validation on Pass or Fail without using the list

  1. #1
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    86

    Data validation on Pass or Fail without using the list

    Dear Expert,

    Do you have any idea how to get a data validation without using list?
    Just using Pass/P or Fail/F

    For example,
    Column A Column B
    Report 001 PASS/P
    Report 002 FAIL/F

    Hope to hear from you soon.
    Thanks.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,085

    Re: Data validation on Pass or Fail without using the list

    If you want to restrict entry to either Pass or Fail, 1st select List under Allow, then for Source, enter "Pass", "Fail"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    86

    Re: Data validation on Pass or Fail without using the list

    Hi FDibbins,

    Thanks for your reply.

    It is a normal to use a list as data validation. How do I use data validation without using the list under Allow, but just key in PASS or P / FAIL or F?

    Hope to hear from you soon.

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,490

    Re: Data validation on Pass or Fail without using the list

    Is it are you looking for?
    Attached Images Attached Images

  5. #5
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    86

    Re: Data validation on Pass or Fail without using the list

    Dear bebo021999,

    Thank you very much for your amazing reply.

    Yes, this is what I am looking for.

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,490

    Re: Data validation on Pass or Fail without using the list

    Nice to hear it works.
    Anyway, without dropdown list, users may confuse because they dont know what to type in that cell.

  7. #7
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    86

    Re: Data validation on Pass or Fail without using the list

    Dear bebo021999,

    Use Input Message at the data validation for each cell.

  8. #8
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    86

    Re: Data validation on Pass or Fail without using the list

    Dear bebo021999,

    Too happy until i have a small query.

    How to fix the only this format "Pass" or "Fail" rather than this format "PASS" or "FAIL"?

    Thanks.

  9. #9
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    6,490

    Re: Data validation on Pass or Fail without using the list

    EXACT will help :

    =OR(EXACT(B2,"Pass"),EXACT(B2,"Fail"))

  10. #10
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    86

    Re: Data validation on Pass or Fail without using the list

    Dear bebo021999,

    That is so good. Finally.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help picking Pass/Fail status text from spreadsheet list
    By Junkyardgary in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-15-2020, 12:48 PM
  2. Help picking Pass/Fail status text from spreadsheet list
    By Junkyardgary in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-14-2020, 03:26 PM
  3. Pass/fail result from data table
    By ms85 in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 08-06-2015, 12:20 PM
  4. Mark Pass/Fail Using Vba for the Huge amount of data
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 12-16-2014, 03:36 PM
  5. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  6. Need a formula to Pass/Fail data entered based on several variables....
    By smurf0617 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2013, 01:10 PM
  7. Matching 2 columns of data Pass Fail or Blank
    By testpilot in forum Excel General
    Replies: 1
    Last Post: 03-05-2009, 09:50 PM

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