Hi, I want to find the smallest number for each category with some formulae. To make it easier to explain, I attache the file here. Column C is the results that I want to get. Can you have a look?
Hi, I want to find the smallest number for each category with some formulae. To make it easier to explain, I attache the file here. Column C is the results that I want to get. Can you have a look?
Just got the answer: use array as decribed in the similar post:
http://www.mrexcel.com/forum/excel-q...riteria-2.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks