Excel: find the lowest/ highest values for rows or columns w/ conditional formatting by Chris Menard
140.3 هزار بار بازدید -
5 سال پیش
-
You can find the lowest
You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting.
The MIN function finds the lowest value. The MAX function finds the highest value. Combine the MIN or MAX function with Conditional Formatting, and you can find the lowest or highest values by row or columns.
The trick to doing this is using relative reference and selecting the correct range. To know which row has the lowest value, you select B2:E5. The conditional formatting function is =B2=MIN(B$2:B$5).
Chris Menard's website
https://chrismenardtraining.com
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
The MIN function finds the lowest value. The MAX function finds the highest value. Combine the MIN or MAX function with Conditional Formatting, and you can find the lowest or highest values by row or columns.
The trick to doing this is using relative reference and selecting the correct range. To know which row has the lowest value, you select B2:E5. The conditional formatting function is =B2=MIN(B$2:B$5).
Chris Menard's website
https://chrismenardtraining.com
And make sure you subscribe to my channel!
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
5 سال پیش
در تاریخ 1398/05/12 منتشر شده
است.
140,356
بـار بازدید شده