Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 06-28-2015, 12:43 AM
Kevin@Radstock Kevin@Radstock is offline Need help with MIN IF AND Windows 8 Need help with MIN IF AND Office 2013
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

AGGREGATE Function:

=AGGREGATE(15,6,A1:F1/((A1:F1<>0)*(A1:F1<>1)),1)
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 11:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft