I am a newbie to excel and don’t really know where to start with this formula.
Basically I would like to do the following:
If a1 is >= than b1 then leave c1 empty however if a1 is < Than b1 then put in today’s date in c1. However, what I want to achieve is that once the date has populated c1 I want that date to hold until a1 is >= than b1. The data for a1 is automatically refreshed every day and the number goes up and down.
To give you a clearer picture of what I want to achieve:
Column A = current share price
Column B = highest share price
Column C = date of highest share price
If a share hits the highest price and then slowly declines over the following weeks I want to identify what date it hit its peak.
Thank you in anticipation
Bookmarks