Let's say My criteria is :
1 2 3 4 5 6 7 8 9 10 J Q K A (13 ranks of cards)
s c d h (4 different suits...s=spades c = clubs,etc)
5 would be the number of draws of 1 card to make a poker hand
How would I go about listing the 2, 598, 960 different poker hands in separate cells?
Like the one at the casino machines.
A1 to A52 like this :
A1 value = As (Ace spades)
A2 value = Ah (Ace hearts) etc...etc..
Randomize like this:
Sub Makerandomlist()
Dim v As Variant
With Worksheets("Sheet1")
With .Range("A1:A" & (Range("A65536").End(xlUp).Row))
v = .Value
.Offset(0, 1).Formula = "=Rand()"
.Resize(, 2).Sort Key1:=.Offset(0, 1)
.Offset(0, 1).Value = .Value
.Value = v
End With
End With
End Sub
Transpose [A1:A5] in [C1:G1]
In a hidden column 52 JPG's (all cards in a deck)
using cases how can i do the equivalent of fifty two If's ?
If [A1] = AhThen
ActiveSheet.Shapes("Picture 3").Copy
Range("C1").Select
ActiveSheet.Paste
End If
i am trying to write a simulator for poker. I am struggleing to find the most efficient way to deal out a deck of cards.
If I number each card 1 - 52 i can generate the first card using the randombetween function but lets say it generates the the four of clubs, which is card number "4" out of the cards 1 - 52.
Now the second card i want to generate is one of 51 not of 52. Also i do not want to gererate the four of clubs again.
how to make this as efficient as possible, i wish to use this to do a helluva alot of simulations so the more efficient the code the better.
writing a spreadsheet that interprets poker hands. I've finished, and it works. I have successfully dealt "Texas Hold Em" poker to 10 players, dealt 5 community cards, and then interpreted the best poker hand and declared a winner.
I did it by using separate tables testing whether certain poker hands existed or not, and I used completely intrinsic Excel functions, NO VBA. That's for those of you who said it couldn't be done! I may soon introduce VBA to slow down the calculations using buttons, and simple things, but Excel can do this.
I'm trying to use a formula in conditional formatting to highlight a cell red if the cell contains a 0 but the date shown in another cell has passed. I want to copy the formatting throughout a column but I don't want the cell to highlight if there is no date in the other cell concerned.
View 11 Replies View RelatedI have a list of items (TR Sets) from 1 to 96 in the range B4:B99, with values corresponding to each one (Acid Number) in the range C4:C99. I would like to make a separate list that names each TR Set (using numbers 1-96) that has an Acid Number > 0.1 . Is there a formula to do this?
View 13 Replies View RelatedI have a list of names in column B and either a 1 or 0 in column A as below:
0 A B
1 1 Bob
2 0 Chan
3 0 Lucy
4 1 Billy
On another worksheet I want to be able to list only the names with a 1 in column A. This must be done in another worksheet so I have something like below.
0 A
1 Bob
2 Billy
3
4
Say I have a listing of cells
1,8,57,77,100, 104
I have a number I would like to find that is made up of a number of these cells. Lets say that number is 205, and as such the only possible values that could make that total are 1,100, and 104.
Is there a formula I can run that will allow me to find this number without manually figuring it out.
I am creating an excel sheet where I have a list of names and dates to correspond with each of those names. Now, I have another sheet where I want an autopopulated list of those names and dates that are within a range of days since the original date.
For example, I own a company and I want to call back my customers 2 days from the first date, 10 days, 20 days, 30 days, 90 days, 120 days. I have a sheet where I have all my customer's information (Name, contact number, date joined the company etc.). Now, I on a separate sheet, when I enter the current date I want an autopopulated list of which customers I can call back within the 2-4 days, 10-12 days, 20-22 days, 30-32 days, 90-92 days, and 120-122 days.
I'm trying to separate text from numbers into two separate cells...
Essentially, I would like the users to copy and paste data into Column A, as seen below. Then, hopefully by formula separate the text characters into Column B and the numbers into Column C.
Input: Output 1: Output 2:
Col A Col B Col C
Wells 123 Wells 123
Wells 1234 Wells 1234
Wells Fargo 123 Wells Fargo 123
Wells Fargo 1234 Wells Fargo 1234
Wells Fargo Inc 123 Wells Fargo Inc 123
Wells Fargo Inc 1234 Wells Fargo Inc 1234
Ideally, I would like to do this with a formula...
I have a table showing accesssibility of given fruits in some particular shops. What I need is to list the fruits available in every shop right after the shop's name, but skipping any empty spaces (i.e. unavailable fruits. See the example, it's manually entered though).
View 2 Replies View RelatedI have a workbook that uses the values that a user had entered into 3 cells to calculate multiple other charts/diagrams on multiple sheets within the workbook. Each sheet would show what the user had entered in the 3 cells to allow them to see what is being used to calculate each table. Is it possible to link these cells so that the user can change the 3 values without having to go back to where he originally entered the 3 values?
For example, a user has entered in 3 values in Sheet 1. A formula in Sheet 2 displays what is entered by the user and uses these calls in Sheet 2 for calculations. When the user wants to change the three values, he would have to navigate to Sheet 1 and enter in the new values to have the workbook recalculate all the tables. Is there a way to link the three cells from Sheet 1 and Sheet 2 so when the user is on Sheet 2, he has the opportunity to change the values on the current Sheet without having to navigate to Sheet 1 to do so?
when i copied data from text to excel it becomes all in one cell ,how can i separate in deferent cells ,file attached
View 3 Replies View RelatedI would like a formula that will take the info from 2 cells (not adjacent to each other or in the same row) and then look these up in a table giving the answer in the 3rd column somewhere else on the worksheet.
View 5 Replies View RelatedNeed to adjust the length of a countif formula from a separate cell
something like this ?
=COUNTIF($BB$23:$BBH21),">0")
H21 being the cell i will change value to indicate rows
Im using a table so I can sort diffrent catagories and I'm trying to put other functions to the right of the table I noticed as I change the sort on the table is moves the information outside the table as well is there a way to seperate that information or do I just need to move it above my table?
View 2 Replies View RelatedI need to find a way of updating cells in two separate worksheets. The cell address can vary.
Right now I am using a "button" which when clicked updates the cell value by an increment.
Is it possible to that the contents of a single cell and and place text of that cell into separate cells? From a web output I have some like the following in my first cell
asdfsdf|adkjoi|fdf234sd|fsf3ie43|||asdfjlkei393|dfjvie|d||adfjei|...goes on with 28 "|"
The text is in A1 and I would like it to take the first string of characters up to the | and place it into cell A2
Then take the next set of characters up to the next | and place into cell A3 and so on.
Once the cell in A1 has been completely separated, go down to the next row and do the same until it reaches the end of the data.
Normally I would create a text file with the web data and then import that in with "|" delimited fields but I don't want to create that extra step for the user.
I have a worksheet with 6,500 rows of data. In each row, there are up to 6 cells containing a name in "Last, First" format. I need to alphabetize the data from these 6 cells so they go across the row in order left to right, alpha by last name.
Example of my data layout:
Column 1 Column 2 Column 3
Row 1 Jackson, Bob / Anderson, Lisa / Cardinal, Mike
Row 2 Tomlinson, Steve / Dodge, Sarah / White, Brian
I need them to be in this order:
Column 1 Column 2 Column 3
Row 1 Anderson, Lisa / Cardinal, Mike / Jackson, Bob
Row 2 Dodge, Sarah / Tomlinson, Steve / White, Brian
Is there a formula I can apply that will pull from only the portion of the data before the comma in each cell? Or do I need to separate out all of the names so the first and last names are in separate columns for this to work?
Is there any way to create a macro for the following:
I have the following format
First Name MI Last Name in Column A.
Sometimes there is a space on the last name for someone with a last name Mc Cormick (for example)
Also, sometimes the list of names is short and sometimes the list of names is long. Is there a way to get a "universal" macro in place, that will not depend on the number of names in the list but will be able to detect when the list ends?
So far I was able to run the macro to get them from text-to-column into cells A, B, and C. However, the middle column sometimes contains the last name if there isn't a middle initial. I need a way to test the middle column for more than one character. If there is more than one character, it is a last name and needs to be in the third column.
I have a table that I've imported into excel. Below are 2 samples of the information in the cells..
A1 = T(APPLICANT_1_RECENT_PROPERTY_TYPE_DESCRIPTION)/V(Unspecified)
A2 = T(APPLICANT_1_RECENT_PROPERTY_TITLE)/V(U)
Basically I would like to separate into 3 columns as such
From A1;
B1 = APPLICANT_1_
C1 = RECENT_PROPERTY_TYPE_DESCRIPTION
D1 = Unspecified
From A2;
B2 = APPLICANT_1_
C2 = RECENT_PROPERTY_TITLE
D2 = U
When Importing I can't use delimited or fixed width. I can do this with Find and Replace and copying cells, but thought there might be a more savvy way to do this.
I have a cell in F2 that looks like this...
513 BLUE RIDGE
Kansas City, MO
(39.104810141000485, -94.47983043799968)
I need to isolate the coordinates in separate cells. IE "39.10481014000485" in cell J2 & "-94.47983043999968" in cell K2. The problem is that some of the cells don't have 14 numbers behind the decimal, and my formula will sometimes grab either the comma ( "," ) or the end parenthesis ( ")" ). Is there a formula I can use to isolate the two coordinate plots?
The good thing is every cell is formatted exactly like this. I had been using a formula that looks like this.
=MID(F2,FIND("(",F2)+1,18)
I think it's close. I just cant figure out how to tell the formula to stop at the first comma, and to stop at the end parenthesis for the second set of coordinates.
The current macro I have allows me to save 'sheet 2' as the name in cell sheet1 B2, which is a 6 digit number. I now want it to save as data from 2 cells, sheet1 B2 followed by sheet1 B1, which is job name (eg. 112233 microsoft excel).
This is the current formula I have:
Public Sub saveworkbook()
Dim filename1 As String
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True, _
IgnorePrintAreas:=False
Sheet1.Select
filename1 = Range("b2")
ActiveWorkbook.SaveAs filename:= _
"C:UsersAndrew.SDocumentsInterloc DocumentsHardware Sheets" & filename1
End Sub
I want to separate the text and numbers into two different cells. Basically, I have the entire drawing details in one cell and I need to split it up, e.g. I have:
KEEP PLATE 902 4 0002
STOOL 525 4 0199
PACK PLATE 525 4 0200
PACK PLATE 525 4 0201
PACK PLATE 525 4 0202
In my Workbook, Sheet 1 i have Cells B2, C2, D2, H2 all with Name, Age, M/F and Fastest time,
on Sheet 3 i have Cells A4, B4 with Under 20 Male and Time.
What i want to know is how do i go about searching the Age and M/F cells and printing the names of the people who fit the criteria ( for under 20 male it would be males aged 16, 17, 18 and 19) into A4 and their time into B4
to make it worse i want to order the times/names in fastest to slowest time .
i can get half way there but i cant seem to get the formula to pick up on >=16 and
a smart formula (no VBA) that will reverse the order of a list of names - parsing into separate columns.
The formula needs to be able to recognize/distinguish that if a comma(s) is present, then the names are listed as last, first middle. If there is a period this means the name has a middle initial or that a suffix is present. So,if the names are listed as last, first and middle then in the next columns will have in the proper order first name, middle name or initial (keep the period) and last name (loosing the comma of course).
If the original name order is in normal order - first middle and last then the formula should just pass through without any change. Would need to preserve generational titles such as Jr., Sr., III etc. Not sure where the best place for the generational titles should end up. Probably as part of the last name. See examples:
Col ACol BCol CCol D Col E
William J. ClintonWilliam J. Clinton
Churchill, Winston Leonard Spencer Winston Leonard Spencer Churhill
Bates, JohnJohn Bates
James Knoll PolkJames Knoll Polk
Taft, William H.William H. Taft
Carter, James, Earl, Jr.James Earl Carter Jr.
Rockefeller, John Davidson, IVJohn Davison Rockefeller IV
Gates, William, H., IIIWilliam H. Gates III
St. James, Michael, Ken Michael Ken St. James
CherCher
I tried using many variations of FIND, SEARCH, LEN and searching all the Excel boards to no avail.
I need a formula which would from one cell extract the words in separate cells. I have probelms because the words in the sentence in the starting cell are not separate by spaces but dots. For example: How.do.I.extract.words.from.this.sentence?
View 7 Replies View RelatedI have a spreadsheet that has a couple of columns that ask for "Move In Date" and the other "Move Out Date". These dates are used in other calculations so there can be only one or the other in each row. I have users that mistakenly either leave both blank or both popluated. Is there a way to stop them with a message telling them that a date needs to be entered or deleted, maybe with data validation?
View 1 Replies View RelatedThis is where you introduce yourself? I make lists for my gf's dad's company using excel. One of my most excruciating tasks is to separate the first and lasts names from one cell into two cells. Does anyone know a quicker way to do this other than manually? I have 10,000 names to do and it's going to be hours if I do it by hand.
View 10 Replies View RelatedI have rxd a pdf file that I need to manipulate I have copied the data into excel and now need it in individual cells:? The data looks like this: 02392950067 19/12/2008 14:33:35 02392950053 Portsmouth 1.9 £0.03. this is:
phone number calling | date called | time called | number called | duration in minutes | cost of call. If you're out there I'd be more than happy to hear from you. the cells to cut the data into will be formatted to take the data in the correct form. 02392950067 19/12/2008 14:33:35 02392950053 Portsmouth 1.9 £0.03
phone number calling | date called | time called | number called | duration in minutes | cost of call.