Dear All
I was wondering whether someone can help me with a formula to achieve the following:
I have a spreadsheet (attached) which shows the dept and their sales. I need a formula to show me the bottom five departments if their sales is not zer. In the attached i need to return the worst department to be 2517 with 5 and then D392 with 5 , D308 with 15 and so on.
My actual spreadsheet has large number of rows and lots of the sales are 0 but I only need to show the bottom 5 departments whose sales were not zero.
Hope this makes sense and thanks in advance
Bookmarks