0 Members and 2 Guests are viewing this topic.

Badger

  • 100+ posts Member
  • ***
  • 138
  • Rated: +7
Could someone kindly help me with Excel coding.

I am trying to look for a repeat in previous spins.
So on spin 2, I check spin 1
On spin 3, I check spin 1,2
On spin 4, I check spins 1,2,3 etc
I have attached an excel sheet to explain what I am trying to do.

The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Nickmsi

  • 250+ posts Member
  • ****
  • 411
  • Rated: +12
Hi Badger,

I have attached a Basic Repeat Tracker that I use.

Hope this helps.

Cheers

Nick
Don't give up . . . . .Don't ever give up.

*

nottophammer

  • 3000+ Posts Member !!!
  • *****
  • 5915
  • How do you win at roulette, simple, right decision
  • Rated: +329
MattyMattz, Nick
=IF(C2="","",IF(C2=1,"x",""))
this is in reply july19, 1:53, what is it asking the spreadsheet to do.

Or should i just ask what do the double speech marks mean and the comma
Thanks from a complete non excel person
How do you win at roulette, simple, make the right decision

Badger

  • 100+ posts Member
  • ***
  • 138
  • Rated: +7
Hi Nick. Thanks as always for your help.
I use this formula : =IF(ISNA(INDEX(B4:B12,MATCH(B13,B4:B12,0))),"",B13)

However, I have to keep changing the range on the column manually.
So on line 2, I have B1:B2
When I drag the formula down to the cell below it becomes B2:B3, where I want it to
remain B1 and the B2 must change to B3.

The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Nickmsi

  • 250+ posts Member
  • ****
  • 411
  • Rated: +12
Badger, to stop the B1 from changing as you go down the sheet, simply make it B$1 in the first row.

Matty ,will check out when I get back later today

Nick

Don't give up . . . . .Don't ever give up.

Badger

  • 100+ posts Member
  • ***
  • 138
  • Rated: +7
Hi Notto
The "" means an empty or blank cell.
So your formula means : If cell C2 is empty("") then make the new cell empty as well.
However if cell C2 contains a 1, place a x in the new cell, if cell C2 contains any other number make the new cell blank.
Hope that helps.
I also am not an expert on excel. Learning new skills is always good.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Badger

  • 100+ posts Member
  • ***
  • 138
  • Rated: +7
Thanks Nick

 :thumbsup: That's just what I needed to know.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Nickmsi

  • 250+ posts Member
  • ****
  • 411
  • Rated: +12
=IF(C2="","",IF(C2=1,"x",""))

Badger you are correct in explaining this formula. As one gets more experience you could also code:

=If(C2=1,"x","")

It does the same thing but with less code.

Both ways work.

Cheers

Nick

Don't give up . . . . .Don't ever give up.

Badger

  • 100+ posts Member
  • ***
  • 138
  • Rated: +7
Could anybody help me with excel coding.  :(
I am tracking Double Streets, A, B, C, D, E, F
I want to track the last 4 that have come up.
1.     31   F
2.       1   A
3.     21   D
4.       3   A
5.     26   E
6.     28   E
7.    36   F
8.    10   B
9.    35   F
10.       1   A
11.     27   E
12.     23   D

So at spin 6 it will be E,A,D,F
At spin 7 : F,E,A,D
Spin 8 : B,F,E,A  etc

I have attached an excel showing how I do it for the last 2.

The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Badger

  • 100+ posts Member
  • ***
  • 138
  • Rated: +7
For anybody that is interested, I think that this is the solution.

See attached spread sheet.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

*

nottophammer

  • 3000+ Posts Member !!!
  • *****
  • 5915
  • How do you win at roulette, simple, right decision
  • Rated: +329
Hi Badger,Nick
Below; i have at cell I:12; =IF(C12="","1",IF(C12="R","","1"))

It gives C12, 1; meaning it took 1 spin; the same for C13,C14 again 1 spin, but C15 blank,yes a repeat, so i need C16 to read 2; it took 2 spins. Same for C21; 2 spins, and C25 should read 4 spins

I've moved R's and 1's around and now starting to find it impossible to get it to count, do i need to add a count IFS ?
How do you win at roulette, simple, make the right decision

*

Bigbroben

  • 500+ posts Member
  • *****
  • 812
  • Member
  • Rated: +69
If you really want cells in column I to show "" on a repeat, you should use the following in column J:
For J12:
=IF(C11="",1,J11+1)
Then for I12:
=IF(C12="",J12,"")

If you don't mind column I displaying 1111211112111212312123, then, for I12:
=IF(C11="",1,I11+1)

I think....
Life is hard, and then you die.

*

nottophammer

  • 3000+ Posts Member !!!
  • *****
  • 5915
  • How do you win at roulette, simple, right decision
  • Rated: +329
Thanks BBB
But i'm getting all values of 1 and =IF(C11="",1,I11+1) 1's and value error.

Again thanks, i'll carry on with formulas and functons for dummies, be along time getting the right formula thou
How do you win at roulette, simple, make the right decision

*

Bigbroben

  • 500+ posts Member
  • *****
  • 812
  • Member
  • Rated: +69
Notto,

check columns J and K in the attached file, I did as described earlier:




Life is hard, and then you die.

*

nottophammer

  • 3000+ Posts Member !!!
  • *****
  • 5915
  • How do you win at roulette, simple, right decision
  • Rated: +329
How do you win at roulette, simple, make the right decision

 

Popular pages: