Search:

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

Search: Search took 0.00 seconds.

  1. 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. Replies
    2
    Views
    175

    Re: 15 Minute Increment on Vertical Axis

    Solved
  3. 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. Replies
    15
    Views
    380

    Re: Conditional Format: IF formula with AND

    it Works! Thanks for everybodies help!
  5. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. Replies
    3
    Views
    1,286

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

    Hi,

    Do I need to provide more info?
  19. Replies
    3
    Views
    1,286

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

    any suggestions?
  20. Replies
    3
    Views
    1,286

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

    Also the excel spreadsheet has mutiple tabs with charts.
  21. 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...
  22. Replies
    2
    Views
    221

    Re: Excel Solver

    Help!
  23. Replies
    2
    Views
    221

    Excel Solver

    Hello. I'm using Excel Solver and have 2 tables. Table one is prices where my variables cells need to be greater. Table 2 is prices where I want my variable cells to be lower. How should I set...
Results 1 to 23 of 23