Again I seek you assistance please
I have attached an example of what I am trying to achieve
I want to find the date on which the highest value was achieved in a range also the largest number of sales on a date
again your assistance is appreciated
Again I seek you assistance please
I have attached an example of what I am trying to achieve
I want to find the date on which the highest value was achieved in a range also the largest number of sales on a date
again your assistance is appreciated
hi bnwash. try:
=DATE(YEAR(B1),MONTH(B1),MATCH(MAX(E3:E33),E3:E33,0))
and:
=DATE(YEAR(B1),MONTH(B1),MATCH(MAX(D3:D33),D3:D33,0))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Sorry but have tried that and I cannot seem to get it to work?
Sorry - How stupid of me It works fine - I omitted to alter the reference
Thanks again
hi
try dis,
Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks for that - Much apprecciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks