Results 1 to 21 of 21

Count Consecutive 0 starting from the Last non zero cell in a row (excluding blanks)

Threaded View

Intalzky Count Consecutive 0 starting... 03-13-2014, 04:34 AM
aydeegee Re: Count Consecutive 0... 03-13-2014, 03:59 PM
Intalzky Re: Count Consecutive 0... 03-14-2014, 12:14 AM
aydeegee Re: Count Consecutive 0... 03-14-2014, 02:29 AM
aydeegee Re: Count Consecutive 0... 03-14-2014, 05:37 AM
Intalzky Re: Count Consecutive 0... 03-14-2014, 05:48 AM
aydeegee Re: Count Consecutive 0... 03-14-2014, 09:16 AM
Intalzky Re: Count Consecutive 0... 03-14-2014, 09:38 AM
martindwilson Re: Count Consecutive 0... 03-14-2014, 09:41 AM
aydeegee Re: Count Consecutive 0... 03-14-2014, 02:36 PM
bebo021999 Re: Count Consecutive 0... 03-14-2014, 03:00 PM
Intalzky Re: Count Consecutive 0... 03-15-2014, 01:05 AM
Intalzky Re: Count Consecutive 0... 04-26-2014, 02:45 AM
hemesh Re: Count Consecutive 0... 04-26-2014, 03:06 AM
Intalzky Re: Count Consecutive 0... 05-01-2014, 04:40 AM
Intalzky Re: Count Consecutive 0... 05-02-2014, 01:55 AM
hemesh Re: Count Consecutive 0... 05-01-2014, 02:32 PM
hemesh Re: Count Consecutive 0... 05-02-2014, 06:11 AM
Intalzky Re: Count Consecutive 0... 05-02-2014, 06:32 AM
hemesh Re: Count Consecutive 0... 05-02-2014, 06:36 AM
Intalzky Re: Count Consecutive 0... 05-02-2014, 06:42 AM
  1. #12
    Registered User
    Join Date
    03-13-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Count Consecutive 0 starting from the Last non zero cell in a row (excluding blanks)

    Thank you everyone! You're all awesome!

    Alastair's Macro and Martin's formula works perfectly..

    Hi bebo,

    Thanks for your response but I think something is missing in the formula. as it counts the all % including non zero cells
    Last edited by Intalzky; 03-15-2014 at 01:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] MIN value excluding blanks
    By coach.32 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2013, 04:52 PM
  2. [SOLVED] Average for non-consecutive cells, excluding zero values.
    By musik7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2013, 06:11 PM
  3. Count row excluding cell
    By Traveleravi in forum Excel General
    Replies: 5
    Last Post: 04-18-2012, 04:31 AM
  4. Count IF excluding blanks or zeroes
    By Ash in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2006, 07:45 PM
  5. Average, Excluding Zeros, Non-Consecutive Range
    By Coal Miner in forum Excel General
    Replies: 9
    Last Post: 08-04-2005, 06:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1