# Questions tagged [microsoft-excel-2016]

The 2016 version of Microsoft's spreadsheet application. Unlike previous versions, this Office Suite is cross-platform, working on both Windows and OSX. Because of this, when using this tag, it may be applicable to also tag your question with the Operating System you're on.

**0**

**0**answers

### How can I delete a column in sheet 2 based on sheet 1 condition?

**0**

**0**answers

### Excel 2016: How to find a specific name in sheet “A” and and get the adjoining cell's value to a cell in sheet “B”?

**0**

**2**answers

### Division calculation within pivot table values in excel

**0**

**1**answer

### #VALUE! error using excel 2016 nested IF statements

**0**

**1**answer

### How to return first non-blank value with LOOKUP function

**-1**

**1**answer

### Excel - How to delete the infinite blank rows?

**0**

**1**answer

### Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?

**0**

**0**answers

### Excel: Writing a 'report' within a worksheet

**0**

**0**answers

### Excel - automatically updating cell reference when applying conditional formatting to range

**0**

**0**answers

### Excel Chart “Save as Picture” making dates into numbers

**0**

**1**answer

### Excel: Drop down with month instances

**0**

**1**answer

### Combining an Excel IF Statement with VLOOKUP

**1**

**1**answer

### COUNTIF across multiple sheets does not work with SUMPRODUCT

**1**

**0**answers

### Excel table.combine({Sheet1},{Sheet2}) erases data on an append

**0**

**2**answers

### Excel: Return all matches in columns using one criteria (from drop down)

**0**

**1**answer

### Changing the layout of an Excel Sheet

**0**

**3**answers

### How to split a string by certain length in excel and put it into columns

**0**

**1**answer

### Blocking certain rows for certain users when sharing an excel-sheet

**0**

**1**answer

### Conditional formatting for specific group of values/rows based on cell value(s)

**0**

**1**answer

### MSExcel: Is it possible to make an adaptive formula through reference?

**0**

**1**answer

### Cannot Reference Pivot Table headers due to header formatting

**0**

**1**answer

### Open Semicolon Delmited Text File in Excel Via Double Click

**0**

**1**answer

### SUMIFS with three criteria

**0**

**1**answer

### Fillup cell depending on value of another cell

**0**

**3**answers

### Convert the number 1999 to the year 1999 - in date format in Excel

**0**

**0**answers

### MAX/MIN of Groupings of Non-sequential Numbers to Generate a (Data) Range for Each Group

**0**

**2**answers

### excel - group sheets by columns

**0**

**1**answer

### Get the position of the last row in an Excel sheet

**0**

**1**answer

### Create multicategory timeline chart in Excel

**0**

**0**answers

### Excel vba to check if a sharepoint file is in use/editable

**1**

**1**answer

### How to use file path stored in a cell in another cell to refer to a value in excel

**1**

**1**answer

### MsgBox based on 2 values in different cells

**0**

**0**answers

### Excel VBA error handling with workbook open

**0**

**1**answer

### Error from custom function

**3**

**2**answers

### Excel IFBLANK equivalent for IFERROR

**0**

**2**answers

### Excel - How to index and match values using header and subheader?

**0**

**0**answers

### Plotting country outlines in Excel map charts

**0**

**0**answers

### Create a “dashboard” by using a “dynamic sumif”

**0**

**0**answers

### How to get Excel to tell me exactly what the issue is with this file?

**0**

**1**answer

### How to create a Line Chart with a scaled X Axis and Dummy Variables

**0**

**1**answer

### Macro to skip filtered rows

**0**

**0**answers

### Remove old users to speed up shared workbook

**0**

**0**answers

### How can I automatically create groups in Excel based on level hierarchy?

**0**

**1**answer

### How to match cell value to cell format

**0**

**1**answer

### Excel doesn't sum up numbers with 16 digit

**0**

**0**answers

### How can I stack all non-blank cells from a column?

**0**

**0**answers

### Get data from the cell of next row in a table, if a cell is found empty

**0**

**0**answers

### How to delete all emoji from Excel list of phrases?

**0**

**0**answers

### Checking Whether Two Columns Match any Numbers from a Different Column

**0**

**1**answer