Microsoft Excel Tutorials for Analyst

Excel formula for Beginners – How to find Max value ignore all errors in Excel

Hits: 5    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find max value ignore all errors in Excel.   Excel formula for Beginners – How to find max value ignore all errors in Excel Generic formula =AGGREGATE(4,6,values) Summary To get the maximum …

Excel formula for Beginners – How to find Max of every nth column in Excel

Hits: 200    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max of every nth column in Excel.   Excel formula for Beginners – How to find Max of every nth column in Excel Generic formula {=MAX(IF(MOD(COLUMN(rng)-COLUMN(rng.first)+1,n)=0,rng))} Summary To get the max …

Excel formula for Beginners – How to find Larger of two values in Excel

Hits: 12    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Larger of two values in Excel.   Excel formula for Beginners – How to find Larger of two values in Excel Generic formula =MAX(value1,value2) Summary To get the larger, or greater, …

Excel formula for Beginners – How to find Large element with criteria in Excel

Hits: 202    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Large element with criteria in Excel.   Excel formula for Beginners – How to find Large element with criteria in Excel Generic formula {=LARGE(IF(criteria,values),n)} Summary To return the largest values in …

Excel formula for Beginners – How to find Unique values with multiple criteria in Excel

Hits: 7   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Unique values with multiple criteria in Excel.   Excel formula for Beginners – How to find Unique values with multiple criteria in Excel Generic formula =UNIQUE(FILTER(data,(range1=”b”)*(range2>5))) Summary To extract a list …

Excel formula for Beginners – How to find Distinct values in Excel

Hits: 13    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Distinct values in Excel.   Excel formula for Beginners – How to find Distinct values in Excel Generic formula =UNIQUE(data,FALSE,TRUE) Summary To extract a list of distinct values from a set …

Excel formula for Beginners – How to Count unique values with criteria in Excel

Hits: 14   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Unique values by count in Excel.   Excel formula for Beginners – How to Count unique values with criteria in Excel   Generic formula =COUNTA(UNIQUE(FILTER(range,criteria))) Summary To count unique values with …

Excel formula for Beginners – How to find Unique values by count in Excel

Hits: 16 (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Unique values by count in Excel.   Excel formula for Beginners – How to find Unique values by count in Excel Generic formula =UNIQUE(FILTER(data,COUNTIF(data,data)>n)) Summary To extract a list of unique values …

Excel formula for Beginners – How to find Unique values in Excel

Hits: 23   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Unique values in Excel.   Excel formula for Beginners – How to find Unique values in Excel Generic formula =UNIQUE(data) Summary To extract a list of unique values from a set …

Excel formula for Beginners – How to Sort values by columns in Excel

Hits: 8   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort values by columns in Excel.   Excel formula for Beginners – How to Sort values by columns in Excel Generic formula =SORT(data,index,order,TRUE) Summary To sort values by columns, you can use …

Excel formula for Beginners – How to Sort text by length in Excel

Hits: 13   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort text by length in Excel.   Excel formula for Beginners – How to Sort text by length in Excel Generic formula =SORTBY(data,LEN(data),-1) Summary To sort text strings by length in ascending …

Excel formula for Beginners – How to Sort by two columns in Excel

Hits: 10 (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by two columns in Excel.   Excel formula for Beginners – How to Sort by two columns in Excel Generic formula =SORTBY(data,col1,order,col2,order) Summary To sort by two columns, you can use the SORTBY …

Excel formula for Beginners – How to Sort by random in Excel

Hits: 10 (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by random in Excel.   Excel formula for Beginners – How to Sort by random in Excel Generic formula =SORTBY(rng,RANDARRAY(COUNTA(rng))) Summary To sort a list or table in random order, you can …

Excel formula for Beginners – How to Sort by custom list in Excel

Hits: 10   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by custom list in Excel.   Excel formula for Beginners – How to Sort by custom list in Excel Generic formula =SORTBY(rng,MATCH(rng,custom,0)) Explanation To sort a list in a custom order, you …

Excel formula for Beginners – How to get Sequence of years in Excel

Hits: 7   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to get Sequence of years in Excel.   Excel formula for Beginners – How to get Sequence of years in Excel Generic formula =DATE(SEQUENCE(12,1,YEAR(A1)),MONTH(B5),DAY(A1)) Explanation To generate a series of dates by year, …

Excel formula for Beginners – How to get Sequence of times in Excel

Hits: 9   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to get Sequence of months in Excel.   Excel formula for Beginners – How to get Sequence of times in Excel Generic formula =TIME(SEQUENCE(n,1,HOUR(start),1),0,0) Explanation To generate a sequence of times, you can …