Hello,
I have list of 1440 numbers (range from 1 to 5) in column A.
I'm trying to find a rule which explains when number 5 will show up.
For example, there is sequence of numbers 3,4,3,2,3,2, and then 5.
Is possible to somehow explain when number 5 will show (some sort of prediction or model)?
What should I use to achieve this? (Excel sheet is attached)
Re: Rule finder in Excel
B1: =IF(A1=5,TRUE,"") and drag down
or
select whole range, go to Conditional Formatting.
cf5.jpg
Last edited by sandy666; 12-23-2017 at 07:10 AM.
Sorry, probably you misunderstood question.Originally Posted by sandy666
I'm not trying to find position of number 5, I'm trying to predict when number 5 will show up.
For example, if we imagine the empty list and we start to add numbers 4,2,3,4,3 etc. I want to predict when
the number 5 will be added while using attached excel sheet (Book123) as sample.
This list is a sample and I'm trying to explain when number 5 will show up.
This is collected data in the past and I didn't know the exact sequence before.
Last edited by Blue11440; 12-23-2017 at 07:46 AM.
oh so, calculus of probability
I'll look at this later
in the meantime maybe someone else will give you solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks