+ Reply to Thread
Results 1 to 5 of 5

PAN Validation

  1. 08-02-2014, 05:15 AM #1
    ANEPM9789M is offline
    Registered User
    Join Date
    08-02-2014
    Location
    Bangalore
    MS-Off Ver
    2010
    Posts
    1

    PAN Validation

    HI,

    Please help me with PAN verification solutions.

    Regards,
    Srinivas.
    Reply With QuoteRegister To Reply
  2. 08-02-2014, 06:31 AM #2
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: PAN Validation

    ??????????????????????
    =if(and(isaboy(a1),isneverland(b1),canfly(c1),d1="peter"),"yep it's a PAN","no it isnt")
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 08-02-2014, 06:50 AM #3
    excelliot is offline
    Forum Contributor
    Join Date
    06-24-2005
    Location
    excelliot.com
    MS-Off Ver
    2007
    Posts
    325

    Thumbs up Re: PAN Validation

    i had made a utility long ago..

    Chek this...


    Cheers!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-02-2014, 07:19 AM #4
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: PAN Validation

    @excelliot

    The code you use is protected with an password.

    Please upload a new file, without an password.

    Or

    Add the code between tags on this forum.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  5. 08-02-2014, 08:12 AM #5
    excelliot is offline
    Forum Contributor
    Join Date
    06-24-2005
    Location
    excelliot.com
    MS-Off Ver
    2007
    Posts
    325

    Re: PAN Validation

    Oppzz.. i forgot that its VBA forum..

    code goes here...

    Please Login or Register  to view this content.
    Cheers!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Dependant Validation. Show error or blank if Inital Validation Changes
    By marsham in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-20-2013, 04:24 PM
  2. Date and count validation in single cell - Custom Validation
    By murugavelmsc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2013, 05:25 AM
  3. Data Validation - Alternative Methods to View Validation Content
    By IASJOE in forum Excel General
    Replies: 2
    Last Post: 11-24-2010, 01:07 PM
  4. validation rules not working when someone copy paste data on validation cell
    By jthakrar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-17-2010, 03:36 AM
  5. data validation-Can the source of the validation criteria be dfrom a different sheet?
    By yael pinkert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2009, 04:28 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1