Results 1 to 20 of 27

Thread: How to list dates defined by a data validation process

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-18-2024, 08:42 AM #10
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    Quote Originally Posted by Aussiebear View Post
    later on when the temps fall the Minimums will be a deciding factor.
    While I'm at it, I tweaked the formula, so the attached:
    • uses temperature thresholds (no data validation dropdown to allow free entry of any values) in cells I37 and I38
    • plots those thresholds as dotted lines on the chart
    • plots green blocks on the chart to show opportunities.

    Hopefully this makes it a bit more visual and easy to check it's giving the right results

    (Still no 'last n days' adressed!)
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules