# Search:

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

Page 1 of 6 1

1. ## Thread: Small Macro Question

by americanpie3
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. ## Thread: Lookup or IF or Index not sure what to do

by americanpie3
Replies
5
Views
221

### Re: Lookup or IF or Index not sure what to do

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

by americanpie3
Replies
5
Views
221

### Re: Lookup or IF or Index not sure what to do

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

by americanpie3
Replies
5
Views
221

### 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. ## Thread: Cannot open excel file by 2x clicking it

by americanpie3
Replies
0
Views
123

### 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. ## Thread: Lookup formulas from previous weeks

by americanpie3
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. ## Thread: Lookup formulas from previous weeks

by americanpie3
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. ## Thread: Lookup formulas from previous weeks

by americanpie3
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
...

by americanpie3
Replies
6
Views
225

### Re: A more Dynamic pread sheet to calculate averages

Hi everyone. I would love to hear more suggestions.

Thanks

by americanpie3
Replies
6
Views
225

### 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...

by americanpie3
Replies
6
Views
225

### 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 ...

by americanpie3
Replies
6
Views
225

### 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. ## Thread: Compare and get result

by americanpie3
Replies
3
Views
213

### Re: Compare and get result

Thanks

K18=605
D18=518

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. ## Thread: Compare and get result

by americanpie3
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. ## Thread: Baseball Innings Pitched

by americanpie3
Replies
4
Views
2,208

### Re: Baseball Innings Pitched

That might be tough to implement in my formula
...
16. ## Thread: Baseball Innings Pitched

by americanpie3
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...

by americanpie3
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. ## Thread: If Index and Match

by americanpie3
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. ## Thread: Calculate with indexing

by americanpie3
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. ## Thread: Calculate with indexing

by americanpie3
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. ## Thread: Too few Arguments

by americanpie3
Replies
4
Views
550

### Re: Too few Arguments

Too many brackets.

Thanks fellas
22. ## Thread: Too few Arguments

by americanpie3
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. ## Thread: If Index and Match

by americanpie3
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. ## Thread: Calculate with indexing

by americanpie3
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. ## Thread: Can Validation>List be Dynamic

by americanpie3
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