Welcome Guest
Log In | Register )
You last visited December 8, 2016, 3:03 pm
All times shown are
Eastern Time (GMT-5:00)

Excel ? trying to count/predict the next pick!

Topic closed. Posted 4 years ago. No replies.

Page 1 of 1
PrintE-mailLink
Avatar

United States
Member #65711
October 4, 2008
39 Posts
Offline
Posted: May 26, 2013, 9:30 am - IP Logged

Hello everyone,

I'm having a hard time finding an excel formula to help me count the numbers that are proceeding or following certain numbers. I've done a search found the sumproduct equations use by Carbob for a similar question but that didn't work. I've also done an internet search and still haven't found my answer. So here is a simple example and wanted out come.

4
5
7
9
8
7
1
9
4
5
7
9
4
3
4

 The numbers proceeding the the number 5 is 4 (two 4s to be exact). I'm looking a formula/ macro to give me the total count of all numbers that are proceeding or following a certain number.

 

Thanks for any help.

Alchemist