Excel Min - Free Excel Tutorial

How to Highlight The Highest and Lowest Value in Each Row or Column in Excel

December 11, 2018

This post will guide you how to highlight the highest value in each row or column in Excel. How do I highlight the lowest value in each row and column with conditional formatting function. Highlight Highest Value in Each Row Highlight Lowest Value in Each Row Highlight Highest Value in Each Column Highlight Lowest Value… read more »

How to Display Negative Time Value in Excel

November 14, 2018

This post will guide you how to display negative time value in Excel. How do I change the way negative times are displayed in Excel. How to show negative dates or times with a formula in Excel. Display Negative Time Value Display Negative Time Value with Formula Video: Display Negative Time Value If the cell… read more »

Find the Earliest and Latest Date in a Range of Dates in Excel

November 14, 2018

This post will guide you how to find the earliest date in a range of dates in Excel. How do I get the earliest and latest date in a range with a formula in Excel. How to find the highest and lowest date in a range of dates in Excel. Assuming that you have a… read more »

Find Closest Value or Nearest Value in a Range in Excel

September 14, 2018

This post will guide you how to find the closest value or nearest value in a range of cells or in a column in Excel. How do I find the closest match in a range to a given lookup value in Excel. How to find the closest larger and closest smaller values from a range… read more »

Return Larger or Smaller of Two Values

September 12, 2018

This post will guide you how to get the larger value from two values in excel. How do I get the smaller value from two values in excel. How to calculate the smallest value or largest value from a range of cells in excel. How to compare two cells and return the one with smaller… read more »

Converting Week Number to Date

August 27, 2018

This post will guide you how to convert a week number to a date with a formula in Excel. How do I calculate a date from a week number and a year with formula in Excel. Or how to get week number from a given date with formula in Excel. Convert Week Number to Date… read more »

Limit Formula Result to Maximum or Minimum Value

July 31, 2018

This post will guide you how to limit formula result to a maximum or minimum value in excel. For example, if you want to limit the results of a formula to a maximum value of 200, how to this this in excel. How do I return a formula result only within a specified minimum or… read more »

Split Text and Numbers

June 28, 2018

This post will guide you how to separate text and numbers from one cell in excel. How do I extract numbers from text string with formulas in Excel. Split Text and Numbers with Formula If you want to split text and numbers from one cell into two different cells, you can use a formula based… read more »

How to Extract multiple match Values into different Columns or Rows

December 8, 2017

This post explains that how to extract multiple match values from a range, then put the values into the different columns in excel. And how to extract multiple matches into the different rows. In the previous post, we talked that how to get the position of the nth occurrence of a value in a column,… read more »

How to Create an Array of Numbers

December 8, 2017

This post explains how to return an array of numbers using an excel formula in excel. Create an Array of Numbers If you want to create an array of numbers, you can use a combination of the ROW function, the INDIRECT function or OFFSET function or INDEX function or MIN function to create a new… read more »