View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] kingart69@gmail.com is offline
external usenet poster
 
Posts: 3
Default Help! Minimum Excluding zeros across multiple sheets

Just wanted to say thanks again to both....I ended up using Harlan's
- =SMALL('1:14'!L35,FREQUENCY('1:14'!L35,0)+1) and it works like a
champ. Although I have to admit - I don't necessarily understand that
formula or WHY it works - My experience with arrays is quite limited.
So, I'm glad i asked for help. thanks again, guys!

Todd