Hello guys,
I am stuck with this index array formula, hope anyone can help me out.
Please see attached file where I need to extract (ProductID into J2:J6) the smallest 5 records based on amount column that match criteria values in Column H & also in Column D the amount need to be greater than 0.
Bookmarks