+ Reply to Thread
Results 1 to 10 of 10

VBA to count not equal to cell value

  1. 07-09-2014, 01:06 PM #1
    shiva_reshs
    shiva_reshs is offline
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    VBA to count not equal to cell value

    Hello,

    I need help in creating VBA which would count cell value not equal to "Open" and "Closed"

    Please Login or Register  to view this content.
    What am i missing ?

    Thanks,
    Shiva
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
    Reply With QuoteRegister To Reply
  2. 07-09-2014, 01:24 PM #2
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: VBA to count not equal to cell value

    Hi.

    try
    Please Login or Register  to view this content.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
    Reply With QuoteRegister To Reply
  3. 07-09-2014, 01:43 PM #3
    shiva_reshs
    shiva_reshs is offline
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    Re: VBA to count not equal to cell value

    it displays count as only 1.
    Reply With QuoteRegister To Reply
  4. 07-09-2014, 01:44 PM #4
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: VBA to count not equal to cell value

    Hi
    you have adapt your need

    Or upload you model file
    Reply With QuoteRegister To Reply
  5. 07-09-2014, 01:46 PM #5
    shiva_reshs
    shiva_reshs is offline
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    Re: VBA to count not equal to cell value

    Count of entire B column of Dump sheet. Thats what i am trying..

    To be more clear which I was not above.

    In dump Sheet, I have data in Column B. I need a formula which would count all cell value except for Open and Closed.
    Last edited by shiva_reshs; 07-09-2014 at 01:50 PM.
    Reply With QuoteRegister To Reply
  6. 07-09-2014, 01:54 PM #6
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: VBA to count not equal to cell value

    Hi look
    Please Login or Register  to view this content.
    in column B ("Dump")
    Open
    Open
    marreco
    Closed
    jon
    mark
    Open
    Open
    Open
    Open
    Closed
    Closed
    Closed
    Closed
    Open
    Open
    Resul In D5 = 3
    Reply With QuoteRegister To Reply
  7. 07-09-2014, 02:02 PM #7
    shiva_reshs
    shiva_reshs is offline
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    Re: VBA to count not equal to cell value

    it is working, but Range B2:B17 is not definitive. It may very as per new data. How can we modify it??
    Reply With QuoteRegister To Reply
  8. 07-09-2014, 02:11 PM #8
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: VBA to count not equal to cell value

    Look my file
    https://www.sendspace.com/file/an2ayu
    Reply With QuoteRegister To Reply
  9. 07-09-2014, 02:26 PM #9
    shiva_reshs
    shiva_reshs is offline
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    715

    Re: VBA to count not equal to cell value

    ohh.. its working well in your sheet. How did you/Where you define Range "Rngmarreco" 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 07-09-2014, 02:28 PM #10
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: VBA to count not equal to cell value

    Hi.

    Look
    http://www.exceldigest.com/myblog/20...in-excel-2010/
    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. Count if a cell is equal to the cell in different spreadsheet and is less or equal zero
    By Neyme in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2014, 10:09 PM
  2. [SOLVED] Count cells in a range, starting from first cell with number that does not equal zero
    By ldoherty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2014, 10:06 AM
  3. Count how many times a cell that represent other cell is higher/equal/lower than another
    By PramuajiAjay in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2013, 01:09 AM
  4. [SOLVED] Formulas count cells that do NOT equal a cell
    By boll55 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-01-2012, 08:53 AM
  5. cell to equal a count of a row and colum
    By MYESKEY in forum Excel General
    Replies: 6
    Last Post: 10-13-2011, 01:59 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1