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

I'm looking to take a list of twenty numbers and count the number of times in
that list two or three consecutive numbers appear in it. Any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Counting consecutive numbers in a list

Can you post some sample data and let us know what result you expect?

--
Biff
Microsoft Excel MVP


"Wiseguy91" wrote in message
...
I'm looking to take a list of twenty numbers and count the number of times
in
that list two or three consecutive numbers appear in it. Any ideas?



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 Months in Top Third A.C.G.[_2_] Excel Worksheet Functions 1 March 7th 08 07:30 PM
counting consecutive absences jerry37917 Excel Worksheet Functions 6 October 9th 07 09:22 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 02:06 PM.

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

About Us

"It's about Microsoft Excel"