by Nico Mellett | May 1, 2023 | Excel Functions, post
In a Nutshell The TEXTJOIN function combines the text from multiple ranges and/or strings in one cell. It provides the option to add delimiting characters (ike dashes or spaces) between all the different strings being joined together. Syntax =TEXTJOIN(delimiter,...
by Nico Mellett | Apr 28, 2023 | Excel Functions, post
In a Nutshell The MIN function is used to find the lowest value in a range of values. Syntax =MIN(number1, [number2], …) The arguments (number1 , number2, …) are up to 255 numbers for which you want to find the minimum value. The first one is required; the rest are...
by Nico Mellett | Apr 22, 2023 | Excel Functions, post
In a Nutshell The CONCAT function combines the text from multiple ranges and/or strings. Syntax =CONCAT(text1, [text2], …) The arguments (text1, text2, …) are up to 253 items to be joined. Each argument listed in the brackets can either be a string, or an array of...
by Nico Mellett | Apr 20, 2023 | Excel Functions, post
In a Nutshell The MAX function is used to find the greatest value in a range of values. Syntax =MAX(number1, [number2], …) The arguments (number1 , number2, …) are up to 255 numbers for which you want to find the maximum value. The first one is required; the rest are...
by Nico Mellett | Apr 2, 2022 | post, Tutorial
Problem How do I highlight all of the duplicate values in a cell range? Background You can use Excel to easily identify duplicate values in a range. We will look at two simple methods. Download the example file here and try it out for yourself. METHOD 1: Automatically...
by Nico Mellett | Feb 7, 2022 | Excel Functions, post
In a Nutshell To CONCATENATE is to “Join” or “Combine” data together. Assume you have numerous columns of data to combine, and manually combining the data isn’t a possibility. You can use the CONCATENATE function to combine content from...