# Search:

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

1. ## Thread: Multiple Routes on Single Map

by tennisbuck
Replies
0
Views
522

### Multiple Routes on Single Map

Good Afternoon,

I know this isn't an Excel question, but I was hoping someone on this board could help. I need to create mutiple routes on a map and was wondering if anyone new of a free service...
2. ## Thread: 15 Minute Increment on Vertical Axis

by tennisbuck
Replies
2
Views
175

Solved
3. ## Thread: 15 Minute Increment on Vertical Axis

by tennisbuck
Replies
2
Views
175

### 15 Minute Increment on Vertical Axis

Hi,

How do I change the vertical axis to 15 min intervals? I have a custom formal of the values hh:mm
4. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Re: Conditional Format: IF formula with AND

it Works! Thanks for everybodies help!
5. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Re: Conditional Format: IF formula with AND

When I use the formula =AND(C3=Sheet1!\$A\$3,B3-TODAY() > = 305) it doesn't turn yellow

Column C=NO and I moved the hire date back to 8/13/2014 which -Todays date is greater then 305 days
6. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Re: Conditional Format: IF formula with AND

When I use the formula =AND(C3=Sheet1!\$A\$3,B3-TODAY() > = 305) it doesn't turn yellow

Column C=NO and I moved the hire date back to 8/13/2014 which -Todays date is greater then 305 days
7. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Re: Conditional Format: IF formula with AND

It doesn't turn yellow, with this formula =AND(C3=Sheet1!\$A\$3,B3-TODAY() > = 305).

I have Column E date 7/24/18. This means Hire Date-Todays date is greater then 305 days
8. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Re: Conditional Format: IF formula with AND

Yep, the hire date is in Column B. updated formula still doesn't work. Am I using todays date right?

=AND(C3=Sheet1!\$A\$3,B3-TODAY()>305)
9. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Re: Conditional Format: IF formula with AND

heres the formula it still doesn't work, i might be a little dense. Is there a way I can post my workbook?

=AND(C2=Sheet1!\$A\$2,E2-TODAY()>305)
10. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Re: Conditional Format: IF formula with AND

So it doesn't turn yellow: here's the modified formula
=AND(C2=Sheet1!\$A\$2,E2-TODAY()=305)

Sheet 1A2 is just N
11. ## Thread: Conditional Format: IF formula with AND

by tennisbuck
Replies
15
Views
380

### Conditional Format: IF formula with AND

Hi Board,

On the attached spreadsheet, what would be the formula I can use to conditionally format cell E2 to yellow based on the following criteria:

1.) Cell C2=N
2.) Cell E2 is 305 days or...
12. ## Thread: Graphing question Secondary Line

by tennisbuck
Replies
1
Views
113

### Graphing question Secondary Line

Hi Board,

I have two data sets on the secondary axis Rolling Total Goal and Goal. For some reason my goal line isn't going to straight across and its fixed at 44400. Any help?

Mike \
13. ## Thread: If Statement for 3 Values

by tennisbuck
Replies
2
Views
583

### If Statement for 3 Values

Hi,

How would I write a IF statement comparing 3 values. For example the field that it would be referencing would have values cell E51(1,2,3,4,5,6,7,...99). The pull back would be:
1-10 =...
14. ## Thread: Bar and Line Chart

by tennisbuck
Replies
0
Views
147

### Bar and Line Chart

Hello,

I've created a combination chart (bar and line) the problem is that I only have 1 data point for the line. This creates a dot on the graph and I need a line. Does anybody know how to...
15. ## Thread: If with Vlookup formula

by tennisbuck
Replies
0
Views
118

### If with Vlookup formula

Hello,

I'm building a calculator with a drop down with 3 options (Widgets, Wind Dings, Walruses) and I'm trying to pull a value off another sheet based on what the user selects. Would somebody...
16. ## Thread: Time between orders (Example)

by tennisbuck
Replies
1
Views
172

### Time between orders (Example)

Hello,

I'm trying to calculate the average time between orders for a few items and I'm not sure how I would do this. Any suggestions:

<TBODY>
Material XYZ

100</SPAN>
17. ## Thread: Help! VBA Code (Excel to PP macro) Code Included

by tennisbuck
Replies
0
Views
371

### Help! VBA Code (Excel to PP macro) Code Included

<INS style="BORDER-BOTTOM: medium none; POSITION: relative; BORDER-LEFT: medium none; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; WIDTH: 234px; PADDING-RIGHT: 0px; DISPLAY: inline-table;...
18. ## Thread: Excel to powerpoint VBA (2 sets of codes)

by tennisbuck
Replies
3
Views
1,286

Hi,

19. ## Thread: Excel to powerpoint VBA (2 sets of codes)

by tennisbuck
Replies
3
Views
1,286

### Re: Excel to powerpoint VBA (2 sets of codes)

any suggestions?
20. ## Thread: Excel to powerpoint VBA (2 sets of codes)

by tennisbuck
Replies
3
Views
1,286

### Re: Excel to powerpoint VBA (2 sets of codes)

Also the excel spreadsheet has mutiple tabs with charts.
21. ## Thread: Excel to powerpoint VBA (2 sets of codes)

by tennisbuck
Replies
3
Views
1,286

### Excel to powerpoint VBA (2 sets of codes)

Hi Board,

I'm new to VBA but in my limited expereinces it has been very helpful. I have 2 sets of VBA code that I need to combined these 2 sets of VBA.

The first code selects the powerpoint...

by tennisbuck
Replies
2
Views
221

Help!