I have a HUGE spreadsheet that lists every transaction ever done by my company since 2000 (31000+ line items). I have been asked to find out the minimum and maximum price for each part # repaired. Many of them have been repaired more than once and many have a dollar amount of $0.00 which makes it more complex as I need to eliminate that amount. I have used Excel 2003 but I now have 2007. I am far from a guru but I can manage (so far). PLEASE HELP!!!! MY JOB DEPENDS ON IT!
