ExcelAnytime
Search
  • Home
  • Ebook of Excel Formulas
  • Excel VBA Online Tutorial
  • Excel Models
  • Services
  • Feedback
Excel & VBA

Excel & VBA

  • Excel Tips
  • Excel Functions
  • Excel VBA
  • Excel Pivot Tables

Ebook of Excel Formulas

  • Ebook
  • Extract Unique Values
  • Extract Duplicate Values
  • Sort & Rank Values
  • Count Uniques & Duplicates
  • Sum Unique Values
  • Count & Countif
  • Count Non-Contiguous Ranges
  • Sumif & Countif Hidden Cells & Rows
  • Sum & Sumif
  • Sum NonContiguous Ranges
  • Average and Averageif
  • Average NonContiguous Ranges
  • Dates, Days & Months
  • String & Text Formulas

VBA Tutorial Login


VBA Tutorial Login

Free! Excel VBA Online Tutorial

  • Create an account
  • Forgot your password?

Ebook of Excel Formulas

Average of Consecutive Negative Numbers
Average Largest 5 column values, per Matching Id
Average of Last 20 Positive values only in a Column
Average of first 10 values in a column, Ignore Error Values
Average Last 10 column values, exclude Highest / Lowest
Position of First Text Character in a String
Ebook of Excel Formulas
Position of Last Numeric in a String
Calculate End Date (& Time) from Start Date (& Time) and Duration (Work Hours) in Excel
Extract the Number Preceding Specific Text in a String
Extract Text After Last Occurrence of a Number in a String
Position of First Number in a String
Extract Text after Last Blank Space in a String
Split Names - Extract First, Middle & Last Names in Separate Cells
Reverse First Name & Last Name
AVERAGE of Non Contiguous Cells which are Evenly Distributed - Odd or Even rows
AVERAGE of Non Contiguous Cells which are Unevenly Distributed
Sum Diagonal Cells in a Range
SUM Smallest 3 Values in Non-Contiguous Cells with Uneven Intervals
SUM Largest 4 Values in Non-Contiguous Cells of a Row
Assign separate Values to Non-Contiguous Cells and return SUM
SUM Non-Contiguous Ranges of a Column - SUM EACH block of consecutive cells
SUMIF for Non-Contiguous Cells, with Wildcards, for Date Range
SUM of - Last 12 values in a Column, Largest 5 out of Last 12 values, last 12 values Excluding Highest / Lowest
SUM Cell values containing any of the Multiple Values in Full or in Part
SUM Max values of Each Row, in a Multiple Column Range
SUMIF with Date Range, Multiple Month Names / Numbers & Year
SUM AND / OR Criteria for Multiple Columns
Sumif to Exclude Cells Hidden by a Filter
Sumif to Exclude Cells Hidden with the Hide Rows command
Countif Multiple Criteria, relate Criteria to a Value, return SUM
Count Cells in Non-Contiguous Ranges, where a value occurs in whole or in part
COUNTIF for Non-Contiguous Cells, with Wildcards, for Date Range
Count Occurrences of a Value in Column, as a whole or in part
Countif Array Criteria, Multiple Columns, AND / OR conditions
Countif with Array Criteria, using AND / OR criteria
Count number of Cells containing Specific Letter(s)
Count Multiple Occurrences of Array Values
SUM Values for Names which appear only Once
Count Rows with occurrence of atleast one number
Count Continuous Non-Blank cells which appear Last
Count Groups of Consecutive Positive Values
Count Maximum Number of Consecutive Occurrences of a Value
Count Rows containing Multiple specified Values
Count Uniques, Multiple AND / OR Conditions
Count Unique Names, where Name corresponds to Multiple Values
Count Unique Values matching any one of the Multiple values
Count Uniques, Condition in One or Both Columns
Count Once for Occurrence of a Value in all columns of Same Row
Count Uniques Appearing in Only One or in Both Columns
Count Unique values in a Column, with Conditions
Count Unique Values in Excel
Split Values into Multiple Equal Groups
Rank Text Values in Custom Order
Rank & Sort Column Values, Ignoring Error Values
Extract a Sorted List of Unique values in a column
Extract Duplicates once, which are Common in 2 Columns
Extract Values which appear ONLY once, from a Column
Extract Unique sub-strings of 1st 5 Characters from each column cell
Unique List, Sorted in Ascending Order, Appearing in One Column and Not in Other
Unique List Appearing in One Column and Not in Other
Unique List from Single Column, Skip Specific Values
Unique List from Single Column
  • You are here:  
  • Home
  • Ebook of Excel Formulas
  • Excel Formulas Ebook
  • Contact
  • About Us
  • Testimonials
  • Website Use Policy

Back to Top

© 2023 Excelanytime.com All Right Reserved.