Microsoft Office Forums - View Single Post - Need help with MIN IF AND

Thread: Need help with MIN IF AND

View Single Post

Old

06-28-2015, 12:43 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 8

Windows 8

Kevin@Radstock uses Office 2013

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