tennis

  1. R

    Writing VBA macro for generating missing variable

    Hello members, I would like to write VBA macro for listing the missing variables as per below. Among candidates A, B C, D and E. I would like to list down the missing variables (Hobbies), accompanied by the candidates name. <tbody> Hobbies A B C D E Swimming Y Y Y N N Tennis N Y Y Y...
  2. R

    Whole #s as a result dividing by 3

    Hi All I want to divide a number by 3 and distribute it in whole numbers. I found examples online using a bucket and tennis balls but haven't been able to translate it. A1=22 tennis balls, and B,C,D are buckets of tennis distributed into whole numbers B1=8 C1=7 D1=7 Your help is greatly...
  3. J

    How to Transpose large data in Excel?

    Hi all-- I need help on how to transpose a large set of data which contains: year, term, student id, and sports. It gets complicated because there are some students that played multiple sports each term. Here's what the raw data looks like: <tbody> YEAR_CODE TERM_CODE ID NUM SPORTS...
  4. D

    Formula that would pick the last value in a column depending on the value in the next column

    Hi everyone! I need your help with the following issue. I need a formula that would insert into a cell the last value from the first column depending on the wording in the second column. In other words, I need a formula that would insert into one cell the value of 40 (which is the last value...
  5. R

    Scoring System

    Hi, I am trying to create a simple scoring system for sports that use a "legs" and "sets" format (e.g. tennis, darts etc.) I would like the "sets" cell to automatically update as the "legs" cell reaches the required amount of legs to win a set. After that I would like the "sets" cell to...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top