1. C

    sum column of numbers based on id # and other possible criteria

    I am trying to do the following but cannot seem to wrap my head around it. I have a workbook with multiple sheets. For what I am doing I have to pull information from one and compare it to another. It looks something like this: Sheet 1 <tbody> A B C D E F 1 Game # Cards Home ID Home...
  2. N

    Calculation issues.

    I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...
  3. R

    Prints Sheets and SaveAS Macro

    I want to create a macro that Prints 3 sheets from my workbook and then launches the saveAs window The 3 sheets I am looking to print are "Team 1" "Team 2" & "Team 3" Is this possible to do in one macro since there are windows that will pop up for both printing and save as?
  4. A

    Generating Sign In Sheets from a Master Schedule

    I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...
  5. C

    Project Overview

    I have an excel document that details the projects we're working on and who the PM is. plus a lot more detail about that project this is one a tab called Team POAP. I want to create a summary overview on a different tab (called Timer Tracker) that shows the PM down column A and then in each...
  6. P

    If Statement

    Hi - looking for help please I have 2 columns which vlookup values within my tab, they are Team Name last month / Team Name this month. I wish to know if these change and report in Column 3. I have about 7 different team names - for this example - North, South, East, West
  7. D

    Weekly Team and Individual Leaderboard

    Hello, I'm lost (per usual) and have searched long enough that I'm starting to go insane so my next step is to post my questions here. Our sales team is needing/wanting a leader board to not only monitor and display the individual sales but also the team (groups of 4 people) sales. So every...
  8. S

    Combinations and permutations

    I have some work, in an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team. The conditions are as below :- Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget...
  9. S

    Excel Pivot Table "Insert Column"

    Hello, I have the results of a survey in an Excel spreadsheet, like this: <tbody> <tbody> Question </tbody> <tbody> Grade </tbody> <tbody> StrVal </tbody> <tbody> Flowers and Decoration Team </tbody> <tbody> -1 </tbody> <tbody> N/A </tbody> <tbody>...
  10. 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>...
  11. L

    VBA Help Delete Row if 3 conditions met?

    Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Probed, If it is empty check Notes, if also empty delete that Row. In the example below row 8 would be deleted as AI = 0...
  12. L

    VBA Delete Rows if 2 conditions are met

    Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Notes, If it is empty delete that Row. In the example below rows 4 & 5 would be deleted as they have an AI value = 0 and no...
  13. D

    Hockey Pool Updates - Need VBA Help

    What I am attempting to is streamline my process of updating my hockey pool each season. It is a keeper league, and so each team can keep up to 4 players from their previous season's team. The other thing is that when a player is kept, his "draft pick value" is one round higher than his previous...
  14. D

    Help with Index Match formula finding last 4 occurences of the name

    Hi guys, I have a simple Excel sheet which contains data in two sheets (basically a football league schedule) Data is contained in column A (home team) and column B (away team for each match) In column O I manually put the name of the team and formula has to find last four times when...
  15. D

    MS 2016 Excel Chart

    Hi, Looking for some help on excel chart without using VBA codes (if possible). Team :1 $0.27, Team :2 $0.90, Team :3 $4.63, Team :4 $5.32, Team :5 $0.77, Total $11.88, Above table provide total expenditure forecast for each teams for a future event. The data which will update on daily basis. I...
  16. B

    Matrix visual and compare values

    Hello all, I have the below in a Matrix visual. I'd like to add another column in the visual that would compare the "Score" to the %ile columns to give me the correct value. For example, Team A's score is 0.75. This is more than 0.65 but less than 0.76 so it should be in the 25th %ile. Team B...
  17. K

    Help needed to get whole column data as result by choosing a drop-down value in other sheet!

    Hi All I am finding it hard to get results in the following scenario: I have three worksheets Sheet 1, Sheet 2 and Sheet 3 In Sheet 1 I have a drop-down with values i.e. Team 1, Team 2, Team, Team 3 and Team 4. In Sheet 2 I have 4 Columns with the headings Team 1, Team 2, Team, Team 3, Team...
  18. P

    Dashboard for data on multiple worksheets

    I have a file with multiple worksheets. Each worksheet has the same format, and each column shares a lot of the same data. Each worksheet is for a project that my team and I work on. What I would like to do is create a Dashboard for each team member which would show the tasks they are assigned...
  19. S

    Sum non adjacent cells with criteria

    Hello I have data to analyse game result as follows. Every team has to play twice with the same opponent yielding Score1 and Score2. I have to add total score of each player on a table 2 shown below. The main problem is the number of team will be changing. If a team is added then every team...
  20. P

    long line of text to columns

    L team away L team home L home lose etc. I need to split the text to columns at the L (space). That's an L and a space

Some videos you may like

This Week's Hot Topics