# microsoft database question

Discussion in 'Business Applications' started by Rustdog, Jul 9, 2004.

Not open for further replies.

Joined:
Jul 8, 2004
Messages:
10
--------------------------------------------------------------------------------

Hi I have a datbase in microsoft works that i'm having a hard time trying to get out the answers to the questions i ask it because i'm unsure how to ask.My database consists of cards from texas holdem games that i have played.it goes like this;there are five columns containing flop1 flop2 flop3 turn and river.Each title has a card value in it with either a letter or number representing the value of the card and also a letter representing which suit the card is.S for spade d for diamond etc.So the database is in rows of five.
something like this.flop flop2 flop3 turn river
Nothing complex.What I want to ask it is how many time that 2 out of 3 of the first 3 columns are the same suit,either specifically or independently?I guess i would need to use a formula for this, but am usure how to do it.Also, I want to know the standard deviation between each of the two suited flops happening.Thanks

2. ### XL Guru

Joined:
Aug 30, 2003
Messages:
2,702
Are you sure it's a database? You'd probably be better off using a spreadsheet, then you could use a formula such as

=(RIGHT(A1,1)=RIGHT(B1,1))+(RIGHT(B1,1)=RIGHT(C1,1))+(RIGHT(A1,1)=RIGHT(C1,1))

, which returns "1" if 2 of 3 match or "0" if 0 of 3 match. Ugly I know, but it's all I can think of for now.

HTH,
Andy

As Seen On