Excel 2000 - get 'min' command to ignore zero

[dsmith910]

Hi

I have a spread sheet which is intended to calculate the fastest team times at any one show. I've used the 'min' and 'max' commands.

Now I want to get Excel to tell me what the fastest and slowest times are for the team overall. Again I've used the 'min' command.
i.e. =min(C6:C500)

I intend using one row per show - so since the spreadsheet has only just been started only the first few rows have content, thus Excel is returning a blank space as the 'minimum'. How can I get it to ignore the blank rows?

Thanks

Doreen

 

[Zathras]

See thread68-624582 but ignore my posts. xlbo and Bowers74 have your answer (near the bottom of the thread).

 

[dsmith910]

Hi

I've had to print the thread you mention as at first glance I still can't work out where to put the 'min' command - or is it not needed? Still will sit down over the weekend and try and figure out what I should be doing.

Thanks for the help - if I don't manage to get it right - I'll be back.

Doreen

 

[xlbo]

You don't need MIN
the SMALL function replaces it

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244