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
votes
0answers
9 views

Excel: Compare 2 tables and extract rows from both with a duplicate value

I have two sheets listing out customer name, date, invoice number and comments in columns. The data in both of these sheets are different and in a different order. How would I cross reference column A(...
1
vote
0answers
8 views

How to count unique values in a table with several criteria?

I work for a small charity, and I'm trying to write a formula which will tell me each month how many unique individuals have donated in the last two years. A sample set of data is below, but the full ...
0
votes
0answers
16 views

Excel bar chart with gradient values (not percentages) and value lines

I am trying to create a bar chart that has a gradient fill specific to static values and then a line to indicate the actual value.My data is like so:Name TimeA 16B 33C 40D 45And ...
0
votes
1answer
8 views

How to use VBA .SaveAs by copying a number from a cell in the spreadsheet retaining a particular number format?

In Cell A1, I have the number (56,000), which is -56000 (negative fifty-six thousand), formatted as Accounting. However, whenever I use VBA to include that cell value in the filename, it saves it as "...
0
votes
1answer
15 views

How to tell Excel to wait to update a cell (in order to avoid circular reference error)?

Scenario: I am using a variable in a calculation, which I will call fred. I want to calculate fred by dividing the last non-zero entry in column B by that entry's row number.However, where column B ...
0
votes
0answers
18 views

How do distinguish cells with text from blanks in vlookup?

I have a spreadsheet that list the company employee name and employee by code. I capture raw data for everyone but I only want to display the data for specific code(s). So, I have a vlookup to ...
1
vote
1answer
41 views

Formula to SUM values in mulitple columns, based on criteria from another column

I have a sheet with three columns. The first is called "Account Number" (AccNr). The two other contains values related to each account number. It looks like this:AccNr. | Value 1 | Value 21000 ...
0
votes
0answers
47 views

Graph and organize multiple categories with multiple data series each

I'm trying to organize and graph data on some cooling devices in a way that's expandable and easy to modify, i.e. graph only certain coolers, manipulate data/add new calculated data as needed.Here ...
0
votes
1answer
55 views

Why the VBA Code does not work in Excel 2016?

I can not write any VBA code in my Excel 2016 (under win 10)I go to the developer menu and I choose Visual Basic button. then I choose a sheet and I do a double click on it. then Excel goes to ...
1
vote
1answer
39 views

Excel 2016 restart itself when I try recording a macro

I wanted to make a Macro in Excel 2016 (under Win 10). I chose the "Record Macro" button. After opening the floating window and making a name for the macro, I click on the "OK" button. After that, the ...
0
votes
0answers
39 views

Identify unique pairings in Excel [on hold]

In Excel 2016, I have a column of data where each cell contains a comma separated list of two or more strings which indicates that these strings can be considered 'matched' or paired together. I ...
0
votes
0answers
7 views

setting Page header defaults

How can I change the defaults for the page setups. When I call up a spreadsheet, change the page setups to NOT print column and row headers and save the worksheet it does not save the page setups. ...
0
votes
0answers
35 views

Pivot grouping disappears when workbook is closed & reopened

I have a workbook containing multiple pivot tables across different sheets.I spent some time on grouping down these tickets into overall headers.For example, the following rows:Meeting 01/01/...
0
votes
0answers
23 views

Multiple column width and row height setting issue

I'm facing an issue when trying to set the column width and row height in MS Excel 2016.For example if I do the followingSelect the entire columnRight click and select Column WidthEnter 5.6 cm...
0
votes
0answers
30 views

Histogram: use sum, not count

Let's assume I have the category "Accidents per Year" (x-axis) and "Frequencies" (y-axis). The first line would read like: "866,062 people had 1 accident this year". Now I want to create a histogram ...

153050per page