MIN with a possible LOOKUP

[Deb6508]

Hi All,
What I have is a spreadsheet that lists various teams in column A, in column B lists the sum of columns C&D, column C lists the number of correct reviews, column D lists the number of erroneous reviews and column E gives me the percentage of accuracy of each specific row.
What I need is at the bottom of all of the team info is a cell that will give me the cell with the lowest accuracy percentage and I need this for the bottom three teams. The big problem is I have to make sure that there is an amount higher than 0 in column B to ensure I don't include my #DIV/0! teams that haven't had any reviews yet.

Can anyone help me out with this? I know how to do a simple MIN equation but when I have to ensure another cell has a calculation and to do the bottom 3 I am lost.

Thanks to any one that can point me in the right direction!!!

Deb

 

[Deb6508]

I posted this late yesterday but unfortunately I didn't have any luck. I'm hoping by reposting today I may get lucky and someone will have a solution.

Thanks!!!

 

[MrKowz]

Can you please provide some sample data, along with your desired outcome?

 

[Deb6508]

A B C D E
B5001 0 0 0 #DIV/0!
B5002 15 10 5 66.67%
B5003 15 13 2 86.67%



Column A is the Team name in numerical order.
Column B is the total amount of reviews (by adding columns C & D)
Column C is the correct amount of reviews.
Column D is the incorrect amount of reviews.
Column E is the Percentage of accuracy for the Team.

I know how to do a basic MIN up column E to give me the lowest accuracy rate, but some how I need to either ignore the #DIV/0! or make sure there is a number higher than 0 in column B. I also need to show the 3 lowest accuracy percentages on the following cells.
If anyone could help me with that I would be very grateful!!!! I have searched through the history on here for different MIN calculations and have tried to convert a couple l thought would work but haven't had any luck so far.

Thank you so much for any help you can send my way!!!

Deb

 

[MrKowz]

Ideally, fix the error at the source by eliminating the Div/0 errors.

Try replacing those formulas with:

=IF(B2=0,"",C2/B2)

Then you can use the MIN function on column E without having to worry about errors.

 

[Deb6508]

Thank you so much MrKowz it works like a charm. If MIN gives me the lowest score what would I have to add to the MIN calculation to get the next to lowest score? Would I add a +1 somewhere possibly?


Deb

 

[MrKowz]

You'll want to use the SMALL function for that instead.

=SMALL(E1:E100,1) - Minimum value
=SMALL(E1:E100,2) - Second smallest value
=SMALL(E1:E100,3) - Third smallest value

etc...

 

[Deb6508]

Thank you so much!!!
Have a GREAT day!!!

Deb