Lüdecke, Hempelmann, and Weiss found that the temperature variation can be explained with six superimposed natural cycles.

With only six cycles they can closely recreate the 240 year central European thermometer record.

Sorting text cells using array formula in excel Table of Contents Sort a column using array formula Two columns sorting by the second column Sort alphanumeric values I am inspired once again by the article Sorting Text in Excel using Formulas at Pointy haired Dilbert.

In Chandoo´s article […]Comments(81) Filed in category: Excel, Sort values Create dependent drop down lists containing unique distinct values Here is a list of order numbers and products. The first drop down list contains unique distinct values from column A.

Instead, we have short records, and Lüdecke et al, make the most of what we have.

Make sure the formula bar looks like this: The formula must have a beginning and ending curly bracket, […]Comments(2) Filed in category: Built-in features, Count values, Excel COUNTIF function Table of Contents Introduction Example 1 - Count with single criterion Example 2 - Count cells larger/less than a criterion Example 3 - Count cells containing a text string Example 4 - Absolute and relative cell reference Example 5 - […]Comments(5) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) COUNTIF(range,criteria) counts the number of cells within a range that meet the given condition NOT(COUNTIF($B

Instead, we have short records, and Lüdecke et al, make the most of what we have.

Make sure the formula bar looks like this: The formula must have a beginning and ending curly bracket, […]Comments(2) Filed in category: Built-in features, Count values, Excel COUNTIF function Table of Contents Introduction Example 1 - Count with single criterion Example 2 - Count cells larger/less than a criterion Example 3 - Count cells containing a text string Example 4 - Absolute and relative cell reference Example 5 - […]Comments(5) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) COUNTIF(range,criteria) counts the number of cells within a range that meet the given condition NOT(COUNTIF($B$1: B1, List)) becomes NOT(COUNTIF("Unique list sorted alpabetically", )) becomes NOT() becomes IF function explained Table of Contents Overview Example 1 - Logical test Example 2 - Value if TRUE/FALSE Example 3 - Nested IFs Example 4 - Many conditions Example 5 - Array formula Download excel *file Overview IF function =IF(logical_test, [value_if_true], [value_if_false]) […]Comments(9) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) MATCH(lookup_value;lookup_array; [match_type]) returns the relative position of an item in an array that matches a specified value MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " MATCH function Table of Contents Overview - Match function Lookup_array in ascending order Lookup_array in any order Lookup_array in descending order Array formula Using wildcard character VBA Example Download excel *file Quick example The formula in cell C3 searches for […]Comments(12) Filed in category: Excel, Functions INDEX(array,row_num,[column_num]) returns a value or reference of the cell at the intersection of a particular row and column, in a given range =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " INDEX function explained Table of Contents Overview Example 1 - array argument Example 2 - row_num Example 3 - column_num Example 4 - area_num Example 5 - Return a range of values Example 6 - Index returns a cell reference Overview INDEX(array, row_num, […]Comments(14) Filed in category: Excel, Functions, Index Create a dynamic named range in excel In this post I am going to explain the dynamic named range formula in Sam's comment.

The formula adds new rows and columns instantly to the named range.

This makes the named range dynamic meaning you don´t need to adjust cell references every […]Comments(12) Filed in category: Excel Explaining OFFSET function In this post I am going to provide some basic examples to demonstrate how the OFFSET function works.

I also show practical examples where I use the OFFSET function.

||

Instead, we have short records, and Lüdecke et al, make the most of what we have.Make sure the formula bar looks like this: The formula must have a beginning and ending curly bracket, […]Comments(2) Filed in category: Built-in features, Count values, Excel COUNTIF function Table of Contents Introduction Example 1 - Count with single criterion Example 2 - Count cells larger/less than a criterion Example 3 - Count cells containing a text string Example 4 - Absolute and relative cell reference Example 5 - […]Comments(5) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) COUNTIF(range,criteria) counts the number of cells within a range that meet the given condition NOT(COUNTIF($B$1: B1, List)) becomes NOT(COUNTIF("Unique list sorted alpabetically", )) becomes NOT() becomes IF function explained Table of Contents Overview Example 1 - Logical test Example 2 - Value if TRUE/FALSE Example 3 - Nested IFs Example 4 - Many conditions Example 5 - Array formula Download excel *file Overview IF function =IF(logical_test, [value_if_true], [value_if_false]) […]Comments(9) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) MATCH(lookup_value;lookup_array; [match_type]) returns the relative position of an item in an array that matches a specified value MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " MATCH function Table of Contents Overview - Match function Lookup_array in ascending order Lookup_array in any order Lookup_array in descending order Array formula Using wildcard character VBA Example Download excel *file Quick example The formula in cell C3 searches for […]Comments(12) Filed in category: Excel, Functions INDEX(array,row_num,[column_num]) returns a value or reference of the cell at the intersection of a particular row and column, in a given range =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " INDEX function explained Table of Contents Overview Example 1 - array argument Example 2 - row_num Example 3 - column_num Example 4 - area_num Example 5 - Return a range of values Example 6 - Index returns a cell reference Overview INDEX(array, row_num, […]Comments(14) Filed in category: Excel, Functions, Index Create a dynamic named range in excel In this post I am going to explain the dynamic named range formula in Sam's comment.The formula adds new rows and columns instantly to the named range.This makes the named range dynamic meaning you don´t need to adjust cell references every […]Comments(12) Filed in category: Excel Explaining OFFSET function In this post I am going to provide some basic examples to demonstrate how the OFFSET function works.I also show practical examples where I use the OFFSET function.

: B1, List)) becomes NOT(COUNTIF("Unique list sorted alpabetically", )) becomes NOT() becomes IF function explained Table of Contents Overview Example 1 - Logical test Example 2 - Value if TRUE/FALSE Example 3 - Nested IFs Example 4 - Many conditions Example 5 - Array formula Download excel *file Overview IF function =IF(logical_test, [value_if_true], [value_if_false]) […]Comments(9) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) MATCH(lookup_value;lookup_array; [match_type]) returns the relative position of an item in an array that matches a specified value MATCH(0, IF(MAX(NOT(COUNTIF($B

Instead, we have short records, and Lüdecke et al, make the most of what we have.

Make sure the formula bar looks like this: The formula must have a beginning and ending curly bracket, […]Comments(2) Filed in category: Built-in features, Count values, Excel COUNTIF function Table of Contents Introduction Example 1 - Count with single criterion Example 2 - Count cells larger/less than a criterion Example 3 - Count cells containing a text string Example 4 - Absolute and relative cell reference Example 5 - […]Comments(5) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) COUNTIF(range,criteria) counts the number of cells within a range that meet the given condition NOT(COUNTIF($B$1: B1, List)) becomes NOT(COUNTIF("Unique list sorted alpabetically", )) becomes NOT() becomes IF function explained Table of Contents Overview Example 1 - Logical test Example 2 - Value if TRUE/FALSE Example 3 - Nested IFs Example 4 - Many conditions Example 5 - Array formula Download excel *file Overview IF function =IF(logical_test, [value_if_true], [value_if_false]) […]Comments(9) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) MATCH(lookup_value;lookup_array; [match_type]) returns the relative position of an item in an array that matches a specified value MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " MATCH function Table of Contents Overview - Match function Lookup_array in ascending order Lookup_array in any order Lookup_array in descending order Array formula Using wildcard character VBA Example Download excel *file Quick example The formula in cell C3 searches for […]Comments(12) Filed in category: Excel, Functions INDEX(array,row_num,[column_num]) returns a value or reference of the cell at the intersection of a particular row and column, in a given range =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " INDEX function explained Table of Contents Overview Example 1 - array argument Example 2 - row_num Example 3 - column_num Example 4 - area_num Example 5 - Return a range of values Example 6 - Index returns a cell reference Overview INDEX(array, row_num, […]Comments(14) Filed in category: Excel, Functions, Index Create a dynamic named range in excel In this post I am going to explain the dynamic named range formula in Sam's comment.

The formula adds new rows and columns instantly to the named range.

This makes the named range dynamic meaning you don´t need to adjust cell references every […]Comments(12) Filed in category: Excel Explaining OFFSET function In this post I am going to provide some basic examples to demonstrate how the OFFSET function works.

I also show practical examples where I use the OFFSET function.

||

Instead, we have short records, and Lüdecke et al, make the most of what we have.Make sure the formula bar looks like this: The formula must have a beginning and ending curly bracket, […]Comments(2) Filed in category: Built-in features, Count values, Excel COUNTIF function Table of Contents Introduction Example 1 - Count with single criterion Example 2 - Count cells larger/less than a criterion Example 3 - Count cells containing a text string Example 4 - Absolute and relative cell reference Example 5 - […]Comments(5) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) COUNTIF(range,criteria) counts the number of cells within a range that meet the given condition NOT(COUNTIF($B$1: B1, List)) becomes NOT(COUNTIF("Unique list sorted alpabetically", )) becomes NOT() becomes IF function explained Table of Contents Overview Example 1 - Logical test Example 2 - Value if TRUE/FALSE Example 3 - Nested IFs Example 4 - Many conditions Example 5 - Array formula Download excel *file Overview IF function =IF(logical_test, [value_if_true], [value_if_false]) […]Comments(9) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) MATCH(lookup_value;lookup_array; [match_type]) returns the relative position of an item in an array that matches a specified value MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " MATCH function Table of Contents Overview - Match function Lookup_array in ascending order Lookup_array in any order Lookup_array in descending order Array formula Using wildcard character VBA Example Download excel *file Quick example The formula in cell C3 searches for […]Comments(12) Filed in category: Excel, Functions INDEX(array,row_num,[column_num]) returns a value or reference of the cell at the intersection of a particular row and column, in a given range =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " INDEX function explained Table of Contents Overview Example 1 - array argument Example 2 - row_num Example 3 - column_num Example 4 - area_num Example 5 - Return a range of values Example 6 - Index returns a cell reference Overview INDEX(array, row_num, […]Comments(14) Filed in category: Excel, Functions, Index Create a dynamic named range in excel In this post I am going to explain the dynamic named range formula in Sam's comment.The formula adds new rows and columns instantly to the named range.This makes the named range dynamic meaning you don´t need to adjust cell references every […]Comments(12) Filed in category: Excel Explaining OFFSET function In this post I am going to provide some basic examples to demonstrate how the OFFSET function works.I also show practical examples where I use the OFFSET function.

: B1, List))*(COUNTIF(List, " MATCH function Table of Contents Overview - Match function Lookup_array in ascending order Lookup_array in any order Lookup_array in descending order Array formula Using wildcard character VBA Example Download excel *file Quick example The formula in cell C3 searches for […]Comments(12) Filed in category: Excel, Functions INDEX(array,row_num,[column_num]) returns a value or reference of the cell at the intersection of a particular row and column, in a given range =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B

Instead, we have short records, and Lüdecke et al, make the most of what we have.

Make sure the formula bar looks like this: The formula must have a beginning and ending curly bracket, […]Comments(2) Filed in category: Built-in features, Count values, Excel COUNTIF function Table of Contents Introduction Example 1 - Count with single criterion Example 2 - Count cells larger/less than a criterion Example 3 - Count cells containing a text string Example 4 - Absolute and relative cell reference Example 5 - […]Comments(5) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) COUNTIF(range,criteria) counts the number of cells within a range that meet the given condition NOT(COUNTIF($B$1: B1, List)) becomes NOT(COUNTIF("Unique list sorted alpabetically", )) becomes NOT() becomes IF function explained Table of Contents Overview Example 1 - Logical test Example 2 - Value if TRUE/FALSE Example 3 - Nested IFs Example 4 - Many conditions Example 5 - Array formula Download excel *file Overview IF function =IF(logical_test, [value_if_true], [value_if_false]) […]Comments(9) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) MATCH(lookup_value;lookup_array; [match_type]) returns the relative position of an item in an array that matches a specified value MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " MATCH function Table of Contents Overview - Match function Lookup_array in ascending order Lookup_array in any order Lookup_array in descending order Array formula Using wildcard character VBA Example Download excel *file Quick example The formula in cell C3 searches for […]Comments(12) Filed in category: Excel, Functions INDEX(array,row_num,[column_num]) returns a value or reference of the cell at the intersection of a particular row and column, in a given range =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " INDEX function explained Table of Contents Overview Example 1 - array argument Example 2 - row_num Example 3 - column_num Example 4 - area_num Example 5 - Return a range of values Example 6 - Index returns a cell reference Overview INDEX(array, row_num, […]Comments(14) Filed in category: Excel, Functions, Index Create a dynamic named range in excel In this post I am going to explain the dynamic named range formula in Sam's comment.

The formula adds new rows and columns instantly to the named range.

This makes the named range dynamic meaning you don´t need to adjust cell references every […]Comments(12) Filed in category: Excel Explaining OFFSET function In this post I am going to provide some basic examples to demonstrate how the OFFSET function works.

I also show practical examples where I use the OFFSET function.

||

Instead, we have short records, and Lüdecke et al, make the most of what we have.Make sure the formula bar looks like this: The formula must have a beginning and ending curly bracket, […]Comments(2) Filed in category: Built-in features, Count values, Excel COUNTIF function Table of Contents Introduction Example 1 - Count with single criterion Example 2 - Count cells larger/less than a criterion Example 3 - Count cells containing a text string Example 4 - Absolute and relative cell reference Example 5 - […]Comments(5) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) COUNTIF(range,criteria) counts the number of cells within a range that meet the given condition NOT(COUNTIF($B$1: B1, List)) becomes NOT(COUNTIF("Unique list sorted alpabetically", )) becomes NOT() becomes IF function explained Table of Contents Overview Example 1 - Logical test Example 2 - Value if TRUE/FALSE Example 3 - Nested IFs Example 4 - Many conditions Example 5 - Array formula Download excel *file Overview IF function =IF(logical_test, [value_if_true], [value_if_false]) […]Comments(9) Filed in category: Excel, Functions "&List) 1), 0, 1), 0)) MATCH(lookup_value;lookup_array; [match_type]) returns the relative position of an item in an array that matches a specified value MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " MATCH function Table of Contents Overview - Match function Lookup_array in ascending order Lookup_array in any order Lookup_array in descending order Array formula Using wildcard character VBA Example Download excel *file Quick example The formula in cell C3 searches for […]Comments(12) Filed in category: Excel, Functions INDEX(array,row_num,[column_num]) returns a value or reference of the cell at the intersection of a particular row and column, in a given range =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1: B1, List))*(COUNTIF(List, " INDEX function explained Table of Contents Overview Example 1 - array argument Example 2 - row_num Example 3 - column_num Example 4 - area_num Example 5 - Return a range of values Example 6 - Index returns a cell reference Overview INDEX(array, row_num, […]Comments(14) Filed in category: Excel, Functions, Index Create a dynamic named range in excel In this post I am going to explain the dynamic named range formula in Sam's comment.The formula adds new rows and columns instantly to the named range.This makes the named range dynamic meaning you don´t need to adjust cell references every […]Comments(12) Filed in category: Excel Explaining OFFSET function In this post I am going to provide some basic examples to demonstrate how the OFFSET function works.I also show practical examples where I use the OFFSET function.

: B1, List))*(COUNTIF(List, " INDEX function explained Table of Contents Overview Example 1 - array argument Example 2 - row_num Example 3 - column_num Example 4 - area_num Example 5 - Return a range of values Example 6 - Index returns a cell reference Overview INDEX(array, row_num, […]Comments(14) Filed in category: Excel, Functions, Index Create a dynamic named range in excel In this post I am going to explain the dynamic named range formula in Sam's comment.

The formula adds new rows and columns instantly to the named range.

This makes the named range dynamic meaning you don´t need to adjust cell references every […]Comments(12) Filed in category: Excel Explaining OFFSET function In this post I am going to provide some basic examples to demonstrate how the OFFSET function works.

I also show practical examples where I use the OFFSET function.