Top "Excel-2011" questions

Wildcard condition with * for SUMIFS formula on a column with number values

I have a huge excel sheet that looks like this: ╔══════╦══════╦═════╗ ║ A ║ B ║ C ║ ╠══════╬══════╬═════╣ ║ Jack ║ 2001 ║ 1,5 ║ ║ Jack ║ 2002 ║ 2,0 ║ ║ Jack ║ 2003 ║ 1,0 ║ ║ Jack ║ 3001 ║ 3,5 ║ ║ Jack ║ 3002 ║ 4,0 ║ ║ Jack ║ 3003 ║ 1,0 ║ ║ Jill ║ 2001 ║ 3,0 ║ ║ …

excel excel-formula excel-2011

Add unknown variables to Excel

Here is a screenshot from my TI CAS: I would like to do the same into an Excel file. I …

excel excel-formula excel-2011

vba excel shape

I've used a small subroutine to insert a picture into my sheet by ActiveSheet.Pictures.Insert(URL).Select This works …

excel vba macos excel-2011

Dynamically construct range to use in XIRR formula

I have a sheet in this form: Fund | Date | Amount A | 10-Jan-05 | -5000 A | 10-Feb-05 | -5000 A | 08-Oct-13 | 12500 B | 10-Sep-05 | …

excel excel-2011