Main Profile

At A Glance

Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm 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
Length: 10:15

Contact

Questions about Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE

Want more info about Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question