Download Excel Start File: people.highlin...
Download workbook: people.highline...
See great use for Excel 2010 AGGREGATE Function.
See how to apply conditional Formatting to show minimum value in row while ignoring #N/A errors and zero Values:
1. Conditional Formatting Logical Formula: =MIN(IF(NOT(ISNA($I2:$M2)),IF($I2:$M2 greater than 0,$I2:$M2,"")))=I2
2. Conditional Formatting Logical Formula Excel 2010: =AGGREGATE(15,6,$B2:$F2/($B2:$F2 greater than 0),1)=B2
AGGREGATE Function Conditional Formatting Format
Негізгі бет Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and
No video
Пікірлер: 32