Archive for MAX function
Column B contains document names, many of them are duplicates. The adjacent column C has the revision of the documents […]
The MAX function allows you to calculate the largest number in a cell range. The formula in cell D3 extracts […]
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.
Combine data from multiple sheets
Question: Problem description (simplified of course): I have a list of employees (by ID number) and date (by yr & […]
Find latest date based on a condition
Table of contents Lookup a value and find max date How to enter an array formula Explaining array formula Download […]
Extract unique distinct values sorted based on sum of adjacent values
Table of Contents Filtering unique distinct text values and sort them based on sum of adjacent values Filtering unique distinct […]
How to highlight MAX and MIN value based on month
Conditional formatting formula to highlight max value in every month: =B2=MAX(IF(MONTH(A2)=MONTH(Date_rng), Close, "")) Conditional formatting formula to highlight min value […]
How to quickly find the maximum or minimum value [Formula]
Question: I have three columns and how do I identify the largest and smallest number? Where is the value? I […]
Welcome! I am 