Month: October 2020

Excel formula for Beginners – How to find Max value on given weekday in Excel

Hits: 59    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value on given weekday in Excel.   Excel formula for Beginners – How to find Max value on given weekday in Excel Generic formula {=MAX(IF(TEXT(dates,”ddd”)=”Mon”,values))} Summary To find the maximum …

Excel formula for Beginners – How to find Max value in given month in Excel

Hits: 38  (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Max value in given month in Excel.   Excel formula for Beginners – How to find Max value in given month in Excel Generic formula =MAXIFS(sales,dates,”>=”&G4,dates,”<=”&EOMONTH(G4,0)) Summary To find the maximum value …

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

Hits: 34    (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: 538    (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: 51    (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: 648    (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 First in – last out times in Excel

Hits: 37   (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find First in – last out times in Excel.   Excel formula for Beginners – How to find First in – last out times in Excel Generic formula =MINIFS(times,names,name,actions,action) Summary To get …

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

Hits: 22   (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: 18    (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: 34   (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 …