+ Reply to Thread
Results 1 to 2 of 2

Count number a column of values passes a certain number

  1. #1
    Forum Contributor
    Join Date
    02-13-2013
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2010
    Posts
    217

    Count number a column of values passes a certain number

    Suppose I have a column A, where the numbers go something like:

    1
    2
    3
    1
    4
    5
    8
    6
    2
    1
    2
    3

    How do I count the number of times we go from a number below 2 to a number greater than or equal to 2?
    So the first count would be 1 -> 2. 2-> does not count because the initial number was not below 2. 1->4 would count since the first number is below 2 and the second is greater than or equal to 2. can i do this with excel?

  2. #2
    Forum Contributor shank_mis's Avatar
    Join Date
    09-08-2018
    Location
    Delhi
    MS-Off Ver
    2010
    Posts
    128

    Re: Count number a column of values passes a certain number

    A bit confusing... Can you show this with an excel sheet ?
    Shashank Mishra
    Please hit "Add Reputation" Button if you liked the answer.

+ 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. [SOLVED] Count number of unique values in Column A that match a term in Column B
    By frsaxon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2016, 07:22 AM
  2. Count number of all unique values down a column
    By nature718 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2014, 08:47 PM
  3. [SOLVED] count number of values in one column if unique value in another.
    By j.farr3ll in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-16-2013, 06:08 AM
  4. Help with using VBA to count number of times different values appear in a column
    By compto in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-06-2012, 12:47 PM
  5. Replies: 3
    Last Post: 08-04-2011, 02:57 PM
  6. Count number of identical values in a column
    By pjkcards in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2010, 09:44 AM
  7. Count number of values equal to MAX of a column
    By dauclair in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 09:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1