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:…
Category: Uncategorized
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”,…
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…
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…
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,”!”,””),”@”,””),”#”,””), “$”, “”), “%”, “”), “^”, “”), “&”, “”), “*”,…
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…
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…
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…
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…
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…