Search:

Type: Posts; User: americanpie3; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    130

    Small Macro Question

    Hi everyone,

    I have an excel file where stats are recorded week to week. I use the macros so that when I do crtl+q it will sort the stats on the sheet StatsWeek1. What I noticed is that I can't...
  2. Re: Lookup or IF or Index not sure what to do

    Sorry, should've copy pasted instead of typing. Thanks!
  3. Re: Lookup or IF or Index not sure what to do

    Giving me #REF !
  4. Lookup or IF or Index not sure what to do

    Hi everyone,

    As you can see by the table below I have the names, averages and then the rank. I use the rank formula so that I can have numbers depending on average.

    Rank Name Averages...
  5. Cannot open excel file by 2x clicking it

    Hi everyone,

    I've upgraded a PC to Office 2013 because the user was having excel issues. Now that I've upgraded I cannot open any excel sheet by 2x clicking them. I have to open excel>File>open...
  6. Replies
    5
    Views
    261

    Re: Lookup formulas from previous weeks

    Hi Andrew,

    I don't want to waste time explaining my sheet but I will say this. Your idea makes the excel sheet very messy and hard to reference. Oh and it's actually 30x30x30 = 27000 PLUS...
  7. Replies
    5
    Views
    261

    Re: Lookup formulas from previous weeks

    Hi Andrew,

    If you look at the formula it's a lot of numbers. Plus there are total of 30 players and for 30 weeks. 1 worksheet won't do it

    Thanks
  8. Replies
    5
    Views
    261

    Lookup formulas from previous weeks

    Hi Everyone,

    I run a dart league and we keep averages week to week and cumulative. The problem I'm having is that my sheets are not dynamic enough. Here's what I would like to do.

    On sheet 1
    ...
  9. Re: A more Dynamic pread sheet to calculate averages

    Hi everyone. I would love to hear more suggestions.

    Thanks
  10. Re: A more Dynamic pread sheet to calculate averages

    Hi old brewer,

    If I understand correctly, your formula only shows how to calculate averages. My question is not about calculating averages but making it more dynamic as in your example, Ann, next...
  11. Re: A more Dynamic pread sheet to calculate averages

    Well it goes like this. We play 6 games in one night. We take each player's 1st scores per game.

    So it would be like
    Game 1 Game 2
    Dan 45 60 100 Dan 45 40 ...
  12. A more Dynamic pread sheet to calculate averages

    Hello everyone,

    I run a dart league. I have a worksheet with players on their teams. Each week I enter the stats. I have stats for averages for the season and per week.

    Per week it runs...
  13. Replies
    3
    Views
    213

    Re: Compare and get result

    Thanks

    K18=605
    D18=518

    Your formula works

    When I reverse D18-K18 I get a -3 result.

    I don't want a negative result and I wonder why a negative result shows up
  14. Replies
    3
    Views
    213

    Compare and get result

    Hi everyone,

    Here's what I would like to accomplish

    The result is in cell B18

    If K18 is greater than D18 by 50 to 99 B18 shows 3
    If K18 is greater than D18 by 100 to 149 B18 shows 6
    If...
  15. Replies
    4
    Views
    2,208

    Re: Baseball Innings Pitched

    That might be tough to implement in my formula
    ...
  16. Replies
    4
    Views
    2,208

    Baseball Innings Pitched

    Hi everyone,

    Is there a way in excel to go to the next digit once 0.3 is reached?

    Example. A pitcher throws on Monday and pitches 7.2 innings. The same pitcher throws on Sunday and pitches 5.2...
  17. Replies
    3
    Views
    166

    Calculate Time

    I know it is simple but need help.

    Column A Row 3 10:30
    Column B Row 3 12:00

    The time I want to display on Column C is 1 hour and 30 minutes

    Column A Row 4 12:00
    Column B Row 4 12:45
  18. Replies
    3
    Views
    349

    Re: If Index and Match

    Here's the SeasonSummary2 worksheet

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color:...
  19. Replies
    4
    Views
    310

    Re: Calculate with indexing

    I have a workbook called Weekx and another called SeasonSummaryx

    I enter all of my player's scores that day on Weekx. Then on that sheet I then have 5 columns. Season average, week's average, High...
  20. Replies
    4
    Views
    310

    Re: Calculate with indexing

    Hi Robert,

    I'm now sure how the averageif works. I've tried it and it doesn't seem to give me the results I want.

    What details would you need of my layout?
  21. Replies
    4
    Views
    550

    Re: Too few Arguments

    Too many brackets.

    Thanks fellas
  22. Replies
    4
    Views
    550

    Too few Arguments

    Someone's arguing.

    =IFERROR(SUM(Week2!AC22:AC24)+(INDEX(StatsWeek1!$B$5:$B$10,MATCH(A5,StatsWeek1!$A$5:$A$10,0)))),0)
  23. Replies
    3
    Views
    349

    If Index and Match

    I tried this and it won't work

    =if(INDEX(SeasonSummary1!D2:D68,MATCH(A2,SeasonSummary1!A1:A68>e2)))

    Basically I want to compare which score ma man Jay has highest between the 2 SeaonSummary...
  24. Replies
    4
    Views
    310

    Calculate with indexing

    Hello,

    As part of a dart league we calculate averages, number of closes and also compare stats week to week.

    I have 1 worksheet that I put in the lineups and all their scores and finishes. Then...
  25. Replies
    5
    Views
    292

    Re: Can Validation>List be Dynamic

    Hi Valko,

    I tried it with the parenthasis and it gave me the same error message.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4