Ashhu
Active Member
I have table where A column list Date and B Price.
I am trying to read top 5 least prices using =Small function, Same time i am looking for Date of corresponding small value using =Index & Match.
Prob: when the 2 least same price falls in top 5, i am able to get date of only first but not the second.
Please see attached for more clarity.
Need your help to fix.
I am trying to read top 5 least prices using =Small function, Same time i am looking for Date of corresponding small value using =Index & Match.
Prob: when the 2 least same price falls in top 5, i am able to get date of only first but not the second.
Please see attached for more clarity.
Need your help to fix.