I need to extract values in sorted order from column E falling in year 2019 (column D) and return and display appropriate match from Column C.
Formula entered in cell G3 is “={IFERROR(INDEX($C$3:$C$14, MATCH(LARGE(IF($G$2=$D$3:$D$14, $E$3:$E$14, ""), ROW(A1)), IF($G$2=$D$3:$D$14, $E$3:$E$14, ""),0)),"")}”
Output is as desired but includes duplicate entries as well. How do I display distinct values only dynamically? I need to accept duplicates coming from column E but while displaying the month in column G, I need to show only distinct months.
Bookmarks