# Excel: How to Create Min Max and Average Chart

Often you may want to create a chart in Excel that displays the minimum, maximum and average values for various groups, similar to the chart below:…

# Excel: Formula for Minimum IF Multiple Criteria

You can use the following basic in Excel to find the minimum value in a range only if multiple criteria are met: =MINIFS(C2:C11, A2:A11, “Mavs”,…

# Excel: How to AutoFill Using a Custom List

The following step-by-step example shows how to autofill values in Excel using a custom list. Step 1: Create Custom List First, let’s enter the values…

# Excel: Use VLOOKUP to Return Multiple Values Horizontally

Often you may want to use the VLOOKUP function in Excel to return multiple values horizontally. Unfortunately this isn’t possible using the VLOOKUP function but…

# How to Remove Special Characters in Excel

You can use the following formula to remove special characters from a cell in Excel: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,”!”,””),”@”,””),”#”,””), “\$”, “”), “%”, “”), “^”, “”), “&”, “”), “*”,…

# Excel: How to Use VLOOKUP by Date

There are two valid ways to use a VLOOKUP by date in Excel: Method 1: Use VLOOKUP with Cell Reference =VLOOKUP(D2, A2:B9, 2, FALSE) This…

# Excel: Use VLOOKUP to Return Blank Instead of Zero

You can use the following formula to return a blank value instead of a zero when using the VLOOKUP function in Excel: =IF(LEN(VLOOKUP(D2,A2:B11,2,0))=0,””,VLOOKUP(D2,A2:B11,2,0)) This particular…

# How to Plot X vs. Y in Excel (With Example)

Often you may want to create a plot of X vs. Y data points in Excel. Fortunately this is easy to do and the following…

# Excel: How to Calculate Cumulative Sum by Group

You can use the following formula to calculate a cumulative sum by group in Excel: =SUMIF(A\$2:A2,A2,B\$2:B2) This particular example assumes that the group values are…

# Excel: How to Check if Date is Between Two Dates

You can use the following formula to check if a date in Excel is between two specific dates: =IF(AND(A2>=\$F\$1,A2<=\$F\$2),”Yes”,”No”) This particular formula returns “Yes” if…