+ Reply to Thread
Results 1 to 5 of 5

Noty equal operator not working??

  1. 11-12-2018, 12:16 PM #1
    RustyNail
    RustyNail is offline
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Noty equal operator not working??

    Hello,

    Why does Excel not accept the following line?

    It complains that it doesn't like the "Criteria1:<>CurDistStr," part ???

    Please Login or Register  to view this content.
    Thanks
    Last edited by RustyNail; 11-12-2018 at 12:21 PM.
    Reply With QuoteRegister To Reply
  2. 11-12-2018, 12:26 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Noty equal operator not working??

    Hi,

    It should be

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 11-12-2018, 12:27 PM #3
    Fluff13
    Fluff13 is online now
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Noty equal operator not working??

    It should be 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 11-12-2018, 03:19 PM #4
    RustyNail
    RustyNail is offline
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Re: Noty equal operator not working??

    Yes That's what I tried and eventually got it!!!!

    Thanks guys
    Reply With QuoteRegister To Reply
  5. 11-12-2018, 03:23 PM #5
    Fluff13
    Fluff13 is online now
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Noty equal operator not working??

    Glad we could help & thanks for the feedback
    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] Not equal operator poiting to a cell value
    By trizzo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-19-2016, 10:35 AM
  2. [SOLVED] "Less than or equal to" operator not working with dates
    By Plastik mac in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2015, 09:14 AM
  3. "Less than or equal to" operator not working with dates
    By Plastik mac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2015, 02:39 AM
  4. [SOLVED] Comparison operator > not working
    By mottoth in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-01-2014, 09:23 AM
  5. Like Operator Not Working for Character List
    By Excel Guy 123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2014, 01:47 PM
  6. [SOLVED] COUNTIF Formula with DOES NOT EQUAL TO operator doesn't work
    By JPWRana in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-20-2013, 06:10 PM
  7. Not Equal To Operator
    By siamadu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2009, 10:22 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