Dear All,
Hello - I am stuck trying to work out way a finding the lowest value between +6 / -6 months of a date.
for example:
Column A contains invoice dates 10K lines of data.
Column B contains unit prices
I am trying to find what the lowest unit price has been 6 months + and - from a specifc date in column A
ie Cell ref A15 is date (1-Sep-xx) I want to find what the lowest price is (Column B) from 6 months prior to and from the date in A15???
Help cant face doing this manually?
thank you
Bookmarks