Tag Archives: Microsoft excel formula

Excel formula for Beginners – How to Sort by one column in Excel

  (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Sort by one column in Excel.   Excel formula for Beginners – How to Sort by one column in Excel Generic formula =SORT(data,index,order) Explanation To sort by one column, you can use the SORT function or SORTBY …

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

  (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 can combine …

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

  (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, you can …

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

  (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 use the SEQUENCE …

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

    (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 months in Excel Generic formula {=EDATE(A1,SEQUENCE(12,1,0))} Explanation To generate a series of dates incremented by month, …

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

    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to get Sequence of days in Excel.   Excel formula for Beginners – How to get Sequence of days in Excel Generic formula =SEQUENCE(days,1,start_date,step) Explanation To generate a series of dates by day, you …

Excel formula for Beginners – How to Find Minimum value if unique in Excel

    (Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Find Minimum value if unique in Excel.   Excel formula for Beginners – How to Find Minimum value if unique in Excel Generic formula =MIN(UNIQUE(range,0,1)) Explanation To find the minimum unique value in …

Excel formula for Beginners – How to FILTER with multiple OR criteria in Excel

(Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to FILTER with multiple OR criteria in Excel.   Excel formula for Beginners – How to FILTER with multiple OR criteria in Excel Explanation To extract data with multiple OR conditions, you can use the FILTER function together …

Excel formula for Beginners – How to Filter with exact match in Excel

(Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to Filter with exact match in Excel.   Excel formula for Beginners – How to Filter with exact match in Excel Generic formula =FILTER(data,EXACT(range,A1)) Explanation To filter data in case-sensitive way, you can use the FILTER function with …

Excel formula for Beginners – How to FILTER to remove columns in Excel

(Excel examples for Beginners) In this end-to-end excel example, you will learn – Excel formula for Beginners – How to FILTER to remove columns in Excel.   Excel formula for Beginners – How to FILTER to remove columns in Excel Generic formula =FILTER(data,(header=”a”)+(header=”b”)) Explanation To filter columns, supply a horizontal array for the include argument. …