Dynamically find min and max values in Excel - Excel Tips and Tricks

preview_player
Показать описание
Learn how to dynamically find min and max values in Excel.

Here is the formula featured in my video.

Minimum Value
=XLOOKUP(MIN(C8:C16),C8:C16,B8:B16)

Maximum Value
=XLOOKUP(MAX(C8:C16),C8:C16,B8:B16)

#tips #excel #shorts #fyp
  1. Rabi Gurung
  2. short
  3. excel short
  4. shorts
  5. Excel tips and tricks
  6. Microsoft Excel tutorials
Рекомендации по теме
Find Min or 0:02:52

Find Min or Max Date with Multiple Criteria | Microsoft Excel Tutorial

Find minimum (Smallest) 0:05:38

Find minimum (Smallest) element in Array

Extracting min date 0:12:49

Extracting min date and Max date dynamically using power query editor

Highlight Max & 0:08:39

Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)

Dynamically highlight Max 0:06:04

Dynamically highlight Max & Min values in Line Chart | MS-Excel

Excel Pro-Tip: How 0:00:44

Excel Pro-Tip: How to Use SUMIFS

Find out max 0:05:16

Find out max and min from array using dynamic memory allocation in C programming | by Sanjay Gupta

EAF #23 - 0:09:49

EAF #23 - Find the Max value in a dataset using criteria - MAX IF Array formula

👍 Highlight Max 0:03:19

👍 Highlight Max and Minimum Values Dynamically in Excel

Find MIN and 0:03:53

Find MIN and MAX of an Array in C++

How to dynamically 0:09:39

How to dynamically highlight min and max values in a chart (Mac)

Highlight Top And 0:06:27

Highlight Top And Bottom Bars Of A Chart Dynamically In Excel - Change Colour Of MIN And MAX Values

Highlighting Max and 0:16:56

Highlighting Max and Min Data Points in Chart Dynamically

How to Set 0:01:32

How to Set Dynamic Min and Max Dates in Chart.js with date-fn Adapter

Figma Tip: Using 0:01:58

Figma Tip: Using Auto layout min and max values

How to dynamically 0:00:50

How to dynamically extract Top 3 and Bottom 3 from a list #excel #exceltips #exceltutorial

HIGHLIGHTING DATAPOINTS in 0:12:38

HIGHLIGHTING DATAPOINTS in Power BI

How to filter 0:07:01

How to filter Min & Max Value (Power Query - Excel & Power BI)

HOW TO HIGHLIGHT 0:03:09

HOW TO HIGHLIGHT MAXIMUM AND MINIMUM VALUES IN POWER BI | HIGHLIGHT MAX AND MIN IN POWER BI MATRIX

Get Most recent/Max 0:02:10

Get Most recent/Max Date value in PowerBI using DAX | MiTutorials

VLOOKUP() to Return 0:13:06

VLOOKUP() to Return the Min Max or Average Value in Excel

Line chart that 0:10:49

Line chart that highlights MAX and MIN values in Excel

Excel Sort Column 0:00:26

Excel Sort Column by Numbers in Ascending/Descending Order (2020)

4.3 Matrix Chain 0:23:00

4.3 Matrix Chain Multiplication - Dynamic Programming

Комментарии
Автор

Great advice. But how to highlight the numbers in the table below?

rohitjain