sports

  1. L

    Find Keyword and Paste in Worksheet with same name

    Hi, I currently have a macro that searches a whole list of sports results that i have already imported (column A:F) and when it finds the name of a team it then pastes that information onto a worksheet with the same name (First 3 letters), whether the team be home or away. It does however only...
  2. R

    Need complex formula for Volleyball league

    We have a volleyball league and we are looking for scheduling formula that can accommodate our leagues format: Number of teams varies from year to year: 12 this year Number of courts varies from year to year: 4 this year (teams/3 and rounded up) Number of weeks varies from year to year: 20 this...
  3. S

    Managing sports into seperate list and a master

    I am trying to create a spreadsheet that will contain the list of all athletes at our school. Other sheets (Tabs at the bottom) are to have each sport and those athletes that participate in that sport. As I add a new student (athlete) to the master list, I want them to add or delete from the...
  4. D

    Soccer stats and relations

    Hi all, I have recently started using PowerPivot to analyze historical soccer results and so far I have been enjoying working with the tool. However, I have come across one obstacle that I can't seem to get past so I hope you are able to help me out. Currently my PowerPivot model has two...
  5. R

    Sports Possession and Territory Calculator

    Hi All I've been trying to set up a Sport Analysis capability for local sports clubs. Many are quite poorly funded and can't afford high end subscription based tools for doing in-game analysis for rugby and football. I've been searching online and haven't been able to track down a free...
  6. N

    Sports Fixture Table in excel

    does anyone know any spreadsheets that have formulas that can possible answer my questions? Task Jo needs to create an ICT solution that will enhance the efficiency of running Westwood Hockey Club. Jo will be the main user of the system. The proposed ICT solution will need to be presented to...
  7. K

    Establishing Sports Standings on Excel, Formulas needed

    I'm trying to tie the name of a team to their wins and losses so that they ascend or descend based on their performance and on other team performances. What exactly would be the formula to establish this linking. It would have to involve both the team name, the team record and win percentage as...
  8. T

    If IsError and WorksheetFunctions

    Hey guys, I am developing a function that does a couple of things. First, the user specifies player names in 'Scores'!A1:A1000, and then various statistics in 'Scores'!B1:G1000. The function loops through these entries, and then updates the corresponding cells in the 'Lifetime Statistics'...
  9. T

    From Row and Column to Cell Position

    Hey guys, I searched the forum for a while and couldn't find anything related to this, so hopefully someone knows a simple way to accomplish what I'm trying to do. What I have going on in a little application I'm developing for a sports league is this: 1) The user selects a name from a...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top