0 Members and 1 Guest are viewing this topic.

Badger

  • 100+ posts Member
  • ***
  • 101
  • Rated: +6
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.


Nickmsi

  • 250+ posts Member
  • ****
  • 408
  • Rated: +11
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 !!!
  • *****
  • 4300
  • How do you win at roulette, simple, right decision
  • Rated: +174
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
  • ***
  • 101
  • Rated: +6
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.


Nickmsi

  • 250+ posts Member
  • ****
  • 408
  • Rated: +11
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
  • ***
  • 101
  • Rated: +6
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.

Badger

  • 100+ posts Member
  • ***
  • 101
  • Rated: +6
Thanks Nick

 :thumbsup: That's just what I needed to know.

Nickmsi

  • 250+ posts Member
  • ****
  • 408
  • Rated: +11
=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
  • ***
  • 101
  • Rated: +6
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.


Badger

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

See attached spread sheet.

 

Popular pages: