Results 1 to 6 of 6

Count maximum times same number used in a row by criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-05-2015
    Location
    norwich
    MS-Off Ver
    365
    Posts
    107

    Count maximum times same number used in a row by criteria

    Tricky one to explain, but example attached.

    Is it possible to count the amount of times a number is used in succession?

    For example if you have in column A the name of the location and Column B a serial number. Can you count the maximum amount of times the same serial number is used in succession for that location name.

    I don't want the total count of the serial number just the maximum times the same one is used in a row

    Sorry for the awful explanation, the example file should be clear though. Thank you for any help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count the number of times data meats a criteria
    By Terry-J in forum Excel General
    Replies: 6
    Last Post: 05-11-2016, 12:45 PM
  2. Count number of times one value is higher than another IF criteria is true
    By LasseKaa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2013, 11:28 AM
  3. Replies: 4
    Last Post: 11-07-2013, 09:41 AM
  4. Counting number of times a maximum exceeds a threshold on a certain frequency
    By varsakov in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2013, 02:21 PM
  5. Macro that sets maximum number of times a workbook is opened
    By Mark1011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2012, 08:41 AM
  6. [SOLVED] how do i count the number of times criteria appears in a worksheet
    By MarkWatson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2006, 02:15 AM
  7. Replies: 3
    Last Post: 02-03-2005, 06:06 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