Results 1 to 7 of 7

Thread: Count consecutive value in a range using formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-27-2012, 08:14 AM #4
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    15
    Quote Originally Posted by Admin View Post
    Hi

    Try this array formula

    =MAX(FREQUENCY(IF(A1:H1=J1,COLUMN(A1:H1)),IF(A1:H1 <>J1,COLUMN(A1:H1))))

    Where J1 houses A

    HTH
    Thanks Admin for your quick response.


    This is exactly what i was lookin for.
    Last edited by LalitPandey87; 04-27-2012 at 08:47 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Count Colored Cells Using Excel Formula
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-15-2013, 11:37 AM
  2. Count Of Numbers Greater Than Zero In Excel Sheet Using Formula
    By MichielV in forum Excel Help
    Replies: 1
    Last Post: 12-04-2012, 05:30 PM
  3. counting consecutive values in an array
    By 5ko in forum Excel Help
    Replies: 3
    Last Post: 12-04-2012, 03:49 AM
  4. Concatinate values in a Range or Array using Native Formula
    By LalitPandey87 in forum Excel Help
    Replies: 3
    Last Post: 04-08-2012, 09:44 AM
  5. Unique Count on a Filtered Range
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-14-2011, 04:29 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