Does anyone know how I can find the smallest non-zero number in Excel using a formula. I've used the MIN function, successfully, on multiple occasions and could use it in combination with the IF function but it is kludgy and requires adding additional columns, etc.

TIA for your help

I'm looking for something that can easily process flat files from a variety of sources - quickbooks, excel sheets, sugarCRM - easy to install and intuitive to setup and run reports on a regular basis. The reports aren't too complicated and I probably could get this setup in Excel but was hoping for something that looks a little more appealing :)

I've briefly looked at Jasper Reports and Pentaho but was looking for something a little more intuitive and easier to manage in an excel like interface, something that could be managed by for a non-technical person (accounting clerk)

Thanks.