played

  1. P

    Need to calculate Average of first 5 non-zero cells in a ROW

    In this example, each score is entered for only the players that played this week leaving lots of blank cells. A new column is added each week between Column D(Hidden) and E. I did this so the arrays in formulas will automatically update when a column is inserted inside the array. In Column...
  2. S

    COUNTIFS or better way there?

    I have a small data that of matches played between two teams. The data looks similar to this. <tbody> Matches data1 data2 data3 Yellow Oak vs Blue Stone Yellow Oak vs Green Grass Oak Blue Stone vs Green Grass Oak </tbody> <tbody> Teams Match Played Yellow Oak Blue Stone...
  3. Q

    Table Lookup

    I'm trying to create a look-up formula that fills in cell values in accordance with corresponding variables from different tabs. For example: In the tab "Match-Up", cell "J3", I'd like the formula to display the number of games "Auburn" has played (according to the data found in tab "Auburn")...
  4. R

    Grabbing Last Value of Column, but...

    As the title says there is more. I have some data (soccer scores). What I want to do is pull the date of the last game PLAYED by each team. I used to have a formula but I can not find it to the best of me. <colgroup><col><col><col span="2"><col><col span="2"><col></colgroup><tbody>...
  5. G

    How to obtain song duration or title of song being played by windows media player

    I want to obtain the duration of a song being played by windows media player or the song title. I have no idea how to do this, please can you help? Not being that good I need code examples to follow or try to adapt. thank you in advance glassescase
  6. S

    Conditional Formatting multiple criteria date based

    I inherited a spreadsheet and the condtional formatting is not working. Using Excel 2016 The formula used is AND(A1>0,Today()-A1>=1,Today()-A1>=1) The next line is AND(A1>0,Today()-A1>=1,Today()-A1>=2) The next line is AND(A1>0,Today()-A1>=1,Today()-A1>=3) The next line is...
  7. M

    Calculating the average ("hitrate") of fotball results

    <style><!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:" ";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px...
  8. R

    VBA or Formula needed for Leadeboard / Games Round Creator - Help required please

    Hi All, In a situation here! Below is a Competition Leaderboard that I am working on for a client. What he wants is for each round, each Player will compete against another based on their position on the leaderboard. For example in the below snapshot Jack played Kevin in Round 2 because they...
  9. E

    How I move the cells from one side to another depending on another cells in Excel VBA?

    Hello I need a little help, I started to learn Excel VBA of a few and that's why I make this appeal to you. I need a VBA code which to replace him the bottom one (that goes, but to enter a code of 20,000 lines seems too many, isn't it?) On short, my problem is : In an Excel sheet I have a...
  10. P

    Calculations

    im trying go calculate teams info easier to show than explain but here goes arsenal is in column A5:a3000 and their game played 42 twice so 84 goes in sheet full data "B5" heres a link to an example book https://www.sendspace.com/file/wsaxti
  11. melodramatic

    Countif with or statement

    OK, I know this is easy, but it's escaping me today. I've got a Lottery table for our group, and part of my calculation of winnings distribution is dependent on how many people have played that month. January thru October is easy - if you paid, you played. About November, we start using our...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top