Hi, I would like some help here. If you see the attached file, we have color and date, When I filter a color, I need to get the oldest date in the empty marked cell... I get the oldest date by using =small(K5:K21), But once I sort it, it gives me the same result which is the oldest of the entire list.
Thank you SO much in advace!