excel again :)

[Badger]

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]

Hi Badger,

I have attached a Basic Repeat Tracker that I use.

Hope this helps.

Cheers

Nick

[nottophammer]

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

[Badger]

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]

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

[Badger]

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]

Thanks Nick

That's just what I needed to know.

[Nickmsi]

=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

[Badger]

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]

For anybody that is interested, I think that this is the solution.

See attached spread sheet.

[nottophammer]

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 ?

[Bigbroben]

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....

[nottophammer]

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

[Bigbroben]

Notto,

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

[nottophammer]