+ Reply to Thread
Results 1 to 7 of 7

Formula to force excel to stop recognising ? as a wildcard?

  1. 04-16-2015, 05:26 AM #1
    TheClaw2323
    TheClaw2323 is offline
    Registered User
    Join Date
    03-06-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    26

    Formula to force excel to stop recognising ? as a wildcard?

    Hi all,

    In the attached example I have a list of project names, some of which are duplicates. In order to remove those duplicates using a subsequent formula I need to assign them each a new number, which the formula in column A is doing.

    However, the formula in column A seems to recognize the '?' in B14 as a wildcard and is not giving that release a new number, instead continuing the count of 4.

    I want to know whether there's a way to get the formula in column A to no longer recognize the '?' as a wildcard, I'm happy to insert new columns if necessary.

    Any help would be greatly appreciated.

    Cheers,

    Chris
    Last edited by TheClaw2323; 04-16-2015 at 06:34 AM. Reason: SOLVED
    Reply With QuoteRegister To Reply
  2. 04-16-2015, 05:28 AM #2
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,891

    Re: Formula to force excel to stop recognising ? as a wildcard?

    hi TheClaw2323

    Please check your thread , Attachment is not found

    Punnam
    Reply With QuoteRegister To Reply
  3. 04-16-2015, 05:30 AM #3
    TheClaw2323
    TheClaw2323 is offline
    Registered User
    Join Date
    03-06-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    26

    Re: Formula to force excel to stop recognising ? as a wildcard?

    Hi Punnam,

    Yeah I accidentally sent before I attached the file and now I'm being really thick and can't work out how to attach it. Any ideas?
    Reply With QuoteRegister To Reply
  4. 04-16-2015, 05:49 AM #4
    TheClaw2323
    TheClaw2323 is offline
    Registered User
    Join Date
    03-06-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    26

    Re: Formula to force excel to stop recognising ? as a wildcard?

    The example spreadsheet should be available to view here:

    https://docs.google.com/spreadsheets...gid=1962456082
    Reply With QuoteRegister To Reply
  5. 04-16-2015, 06:14 AM #5
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,891

    Re: Formula to force excel to stop recognising ? as a wildcard?

    Hi,
    Try this in b3 and drag it down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Punnam
    Reply With QuoteRegister To Reply
  6. 04-16-2015, 06:29 AM #6
    TheClaw2323
    TheClaw2323 is offline
    Registered User
    Join Date
    03-06-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    26

    Re: Formula to force excel to stop recognising ? as a wildcard?

    You sir, are a genius.

    Thank you very much indeed
    Reply With QuoteRegister To Reply
  7. 04-16-2015, 06:32 AM #7
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,891

    Re: Formula to force excel to stop recognising ? as a wildcard?

    hi TheClaw2323,

    Glad to help you , Mark the thread solved .

    Punnam
    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. How to force excel to drag formula by two, rather than one.
    By sasiddiq in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2014, 12:58 PM
  2. IF formula not recognising number
    By ddub25 in forum Excel General
    Replies: 2
    Last Post: 06-23-2012, 06:46 AM
  3. [SOLVED] formula recognising text and numbers
    By james1965 in forum Excel General
    Replies: 5
    Last Post: 05-23-2012, 10:34 AM
  4. How do I force Excel to stop helping me
    By david488 in forum Excel General
    Replies: 2
    Last Post: 11-26-2009, 04:27 AM
  5. Recognising dates for formula output
    By BravoBravo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2008, 01:21 AM

Tags for this Thread

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