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" <JeffT@discussions.microsoft.com> wrote in message
> news:AEA5F7BA-3335-4945-B09B-118F6F0CBB03@microsoft.com...
> > 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
>
>