Skip to main content
2 votes

Parse year only in excel spreadsheet

In your formats, the year is always the last numeric entry. And sometimes there are commas and spaces following the year. In 365, you can use: =TEXTAFTER(TRIM(SUBSTITUTE(A1,",",""))...
Ron Rosenfeld's user avatar
2 votes

How Do I sum a series or rows by a formula that considers two columns in excel

Try using SUMPRODUCT() or SUM() function (if using MS365) • Column Percent 1: =SUMPRODUCT(A2:A3,B2:B3) • Column Percent 2: =SUMPRODUCT(A2:A3,C2:C3)
Mayukh Bhattacharya's user avatar
1 vote

Vlookup inconsistence or confusion(?) using true range lookup

Certainly, you are not using the VLOOKUP() function in the way it has to be used as it works from Left to Right. This is because the LOOKUP() value is Sales Amount whereas in the Table Array the ...
Mayukh Bhattacharya's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible