Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Counting consecutive numbers in a list

Is there a function that will take a list of 20 numbers and count if two or
three of them are consecutive and count how many times this happens within
the list?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting consecutive numbers in a list Wiseguy91 Excel Worksheet Functions 1 January 12th 10 03:52 AM
Counting Consecutive Instances carl Excel Worksheet Functions 3 September 24th 07 07:08 PM
Counting groups of exact numbers in a huge list (column) pgiessler Excel Discussion (Misc queries) 1 August 16th 06 05:00 PM
Counting number of consecutive zeros at the end of a list [email protected] Excel Discussion (Misc queries) 2 September 22nd 05 12:47 PM
how do i make a list of consecutive numbers in a column? mawineguy Excel Worksheet Functions 1 February 15th 05 10:09 PM


All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"