View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bikemrh bikemrh is offline
external usenet poster
 
Posts: 7
Default Minimum function

I am working with a spreadsheet with over 300 rows. I need to use the minimum
function and return the minimum value. This needs to be done on more than 50
non=-consecutive rows.

this is what I have:

=MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,56,60 ,64,68,72,76,80,84,88,92,96,100,104,108,112,116,12 0,124,128,132,136,140,144,148,152,156,156,160,164, 168,172,176,180,184,188,192,186,200,204,208,212,21 6,220,224,228,232,236,240,244,248,252,256,260,264, 268,272,276,280,284,288,292,296,300,304})