New Excel Help Service!

We need your input to help create a new Live Online Excel Help service.

Please take our survey and let us know your thoughts!

Excel Survey

Have a great day!

Don


Featured Excel Content



Excel Tip
How to count the occurrence of the largest or smallest value in a range; basically, how many times the MAX or MIN value occurs in a range. Sections: Max Min Notes Max =COUNTIF(A1:A6,MAX(A1:A6)) A1:A6 is the range with the values. Change that in both places in the formula to fit your data. Result: The MAX() function gets the highest value from the ...
Added: Dec 8, 2016
 
Excel Tip
There are two basic functions that return the most frequently occurring number from a list or range of cells. The MODE() and MODE.SNGL() functions. MODE =MODE(A1:A6) Result: MODE.SNGL =MODE.SNGL(A1:A6) Result: Notes Both functions are really easy to use and they do the same thing. However, MODE() is kept for compatibility purposes for Excel 2007 a ...
Added: Dec 7, 2016
 
Excel Tip
Perform lookups on numbers with partial matches. For instance, find the first number that starts with 12 in a list. This requires an array formula in Excel. The problem is that when you use the asterisk wildcard to find a cell that contains certain numbers, Excel converts the number to text and so you can't perform the lookup without changing the ...
Added: Dec 6, 2016
 
Excel Tip
Return the largest value from a list, or any of the top values, in Excel. This method uses the LARGE() function. Sections: Syntax Example - Largest Value Example - Any Top Value Notes Syntax =LARGE(array, k) Argument Description Array The range from which you want to get the largest value, or just any top value. K Which top value you want to get. ...
Added: Dec 5, 2016
 
Excel Tip
How to count blank cells, including formulas that output a blank. Sections: Count Blank Cells Notes Count Blank Cells A blank cell is an empty cell and also a cell that contains a formula that outputs a blank. Note that a blank looking cell, one that contains only a space in it, will not be counted as blank. =COUNTBLANK(A1:A6) Result: Cells with F ...
Added: Nov 30, 2016
 
Excel Tip
Exclude zeros while averaging cells in Excel. This method removes all zeros from the equation. Sections: Easy Method Method 2 (Used for Excel 2003 and Older) Notes Easy Method This method works for Excel 2007 and later versions, which probably includes you. =AVERAGEIF(A1:A5,"<>0") A1:A5 change this to the range that you want to average and t ...
Added: Nov 29, 2016
 
Excel Tip
How to count the number of errors in a range in Excel; also, how to count the occurrence of a specific error. Sections: Count the Number of Errors Count Specific Errors Notes Count the Number of Errors Count all of the errors that occur in a range. =SUM(ISERROR(A1:A5)*1) Array formula: you must enter this into the cell using Ctrl + Shift + Enter o ...
Added: Nov 28, 2016
 
Excel Tip
Count the number of cells that contain TRUE, FALSE, or one of the two. This lets you count the logical values in a range in Excel. Sections: Count Cells that Contain TRUE Count Cells that Contain FALSE Count Cells that Contain TRUE or FALSE Notes Count Cells that Contain TRUE =COUNTIF(A1:A5,TRUE) A1:A5 is the range in which to count; change it to f ...
Added: Nov 24, 2016
 
Excel Tip
How to get the MAX and MIN values from a filtered data set. This method returns the value from only the visible rows after data has been filtered. To do this, we use the SUBTOTAL() function. Sections: Syntax Example - Filtered Data Example - Exclude Manually Hidden Rows Notes Syntax MAX =SUBTOTAL(4, range) 4 tells the function to return the max val ...
Added: Nov 23, 2016
 
Excel Tip
Perform a Vlookup that returns the highest value, lowest value, or average value from a dataset. Sections: Vlookup to Return Max Vlookup to Return Min Vlookup to Return Average Notes Vlookup to Return Max Return the max value from a table of data. =VLOOKUP(MAX(A1:A5),A1:B5,2,FALSE) Result: This Vlookup function is exactly the same as the regular o ...
Added: Nov 22, 2016
 
Subscribe for Free Excel tips & more!
E-mail: