Good evening - I have been trying to use the Small function on a filtered dataset, but I return all results. I am trying to limit the result set to only those filtered values. Example below:
Unfiltered:
Marty 4 4 4
Patrick 4 4 3
Steve 3 4 2
Walt 3 4 4
Carlos 4 5 3
Formula - Small(B1:B5,1) Should return results of 3, 4, 2
Filtered
Marty 4 4 4
Carlos 4 5 3
Formula - Small(B1:B5,1) still returns the results of 3,4,2 - but I am trying to get the results to be 4,4,3. I know there needs to be some sort of Sumproduct, but it doesnt seem to be working.
Please help and thanks for this forum, I have been googling everywhere to no avail
Bookmarks