Thread: Excel Help
View Single Post
  #2  
Old 19th April 2010, 07:48 PM
Crackone Crackone is offline
Member
  
Join Date: Apr 2006
Posts: 368
Default
this will find the lowest price =MIN(IF($C$2:$C$6000=C2,$J$2:$J$6000,"")) enter with shift control enter, also you could expand the range.

Its a start
Reply With Quote