Search results

I've created a crude Hangman game in Excel 2016. When an incorrect letter is guessed I have to manually run a macro to insert the next body part. What I'd like is to have the next body part inserted automatically after an incorrect letter is entered. How can I do that?

I developed a Farkle scoresheet that my friends and I use when we play. I've been told more than once that I should do one for Yahtzee. Perhaps you wouldn't mind sharing yours with me? You can have a copy of my Farkle scoresheet if you'd like.

On the auto tab I have two buttons attached to macros. The Run Clock macro gets the clock going, but I can't find a way to stop the clock VBA-wise so I can make a macro for the Stop Clock button that will stop the clock. Help!

=OFFSET(E1,(MATCH(G7,E2:E4,0)),(MATCH(G8,F1:H1,0)),1,1)

Depending on your data, this could just be as simple as a format change. If you select the cell with "Friday 1st November", right-click it and select "Format Cells", then if you select "Text" and the Sample shows 43770, all you need to do is re-format your dates.

Would you please upload a sample file and/or include the years in your two examples. Are the days always shown using two digits (e.g. would it be "Saturday 9th November" or "Saturday 09th November"?

You will need to replace the NOW() in this with your date and time: =TEXT((NOW()+TIME(8,0,0)),"dddd, mmm dd, yyyy hh:mm am/pm") If your timestamp is in cell C7, then: =TEXT((C7+TIME(8,0,0)),"dddd, mmm dd, yyyy hh:mm am/pm")

I can only add this - be sure to change the Date dropdown to DMY (in Step 4): Test this way... 1) Select range D2:D10 2) Data > Text to Columns... 3) <Next>, <Next> 4) Select Column Data Format 'Date' Change the Date dropdown from MDY to DMY 5) Keep 'Destination' same 6) <Finish>

Here's my attempt at meeting your requirements. Hope you like it.

Another option: in A4 of Monitor tab put: =INDIRECT("[Data.xlsm]Data!"&ADDRESS(ROW(XFA2),(MATCH(A$3,[Data.xlsm]Data!$1:$1,0)))) Copy across and down as far as needed. Notice the MATCH formula is applied to the entire row, making it possible for you to add as many new columns as you wish to...

Assumptions: - there are 4 players - each player receives 5 random cards from a standard 52-card poker deck - AH, 2H, 3H, ..., JH, QH, KH <= Ace of Hearts, 2 of Hearts, and so on - AD, 2D, ... Diamonds - AS, 2S, ... Spades - AC, 2C, ... Clubs Feel free to take...

I used Excel to do my monthly operational performance reports. It used to take me most of the month to complete the reports covering the previous month. Each month I would automate a little more of my analysis and charting until I could open my new data file, then open my Excel spreadsheet...

But you do need to develop good habits.

I chose VLOOKUP over LOOKUP because support.office.com recommends it: Use VLOOKUP to search one row or column, or to search multiple rows and columns (like a table). It's a much improved version of LOOKUP. https://support.office.com/en-us/article/LOOKUP-function-446d94af-663b-451d-8251-369d5e3864cb

=VLOOKUP(A1,B4:C7,2,TRUE) B4:C7 contain: 0 0 42 5 46 30 50 40

Just offering another way to do it: =IFERROR(INDEX(D4:M4,,MATCH(D7,D3:M3,1)+1),D4)

Please upload a workbook and you'll be much more likely to get responses. The ninjas here are super smart, but I haven't found any of them to be mindreaders.

Lions, tigers, bears, and helper cells, oh my! Who knows, you may like it.

In simplest terms, to transpose 2-dimensional arrays all that has to be done is to change the order of (row,column) to (column,row). Copy this formula to an empty worksheet, change Sheet1 to the name of the tab your data is on, then extend it to the right and down as far as is necessary to...

That's the way I did it, Asheesh.

Fill in the empty multiplication table under the following constraints: only one cell can be filled using the keyboard all other cells must be filled using the mouse only

In D2: =LARGE($B$2:$B$61,ROW(A1)) extend down until you have 15 values In C2: =INDEX($A$2:$A$61,MATCH(D2,$B$2:$B$61,0)) Remember to give me a Like if you like my answer!

Esther, I haven't gotten a response from you regarding the email I sent, so I wonder if you wouldn't mind checking your junkmail folder for it. Thank you, John

Kelly, Please check out my solution. I wasn't sure how you were going to define high vs low scores so I chose the median score and the average score as possible split points. However, you can choose any number you want if you don't like the median nor the average. Also, I corrected your...

Mohit, I took a different approach that is working for me. You can change the month # via a drop-down. Look at a calendar for October 2015, then change the month # to 10 and check your results.