That worked perfectly.
Thanks.
Jeff
"Ragdyer" wrote:
One way,
=IF(ISERR(SMALL($I$3:$I$34,ROW(A1))),"",SMALL($I$3 :$I$34,ROW(A1)))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff T" wrote in message
...
Thanks for the replies. Works great, but when there is no data in the
cells
for the totals, like an empty sheet, the cells with formulas you provided
show: #NUM!
When data is entered into the total column cells the results I'm looking
for
work fine. How can I supress the #NUM! from displaying?
Thanks again,
Jeff
"Jeff T" wrote:
I created an Excel sheet for calculating the cost of items when a value
is
entered in two cells. The formula in cost column for each row is:
=IF(ISERROR(G3/F3),"",G3/F3)
I also have a cell that shows me the lowest number in the column:
=MIN(I3:I34)
I would like to create cells that will show me the next lower number and
then a cell to show the next lower number to that. I would only like to
display the 5 lowest numbers and as you can see I can easily show the
lowest.
I don't know what formula to use in the consecutive cells to show the
next to
lowest and so on.
Thanks for any help.
Jeff
|