Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
1answer
30 views

Find text in the textbox in Excel

I've come to realize the Excel "Find and Replace" dialog couldn't find text in the textboxes. I think I need a macro to solve this. How could I find text in the textboxes: in the active sheet in all ...
0
votes
0answers
21 views

How to export Excel worksheet to another format without changing the original format

I do frequently export Excel worksheets to another format (for example, HTML or CSV), and always get annoyed by Excel changing the original format I was using (XLS or XLSM) to the one used for ...
27
votes
7answers
9k views

In Excel, when I enter 22222.09482 then I see 22222.0948199999 number in the formula bar

Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the ...
0
votes
1answer
27 views

Is there a way to access the built-in excel form via a shortcut?

Is there a way to access the built-in excel form via a shortcut? Macros/VBA and addins are disabled. Users are running either Excel 2013 or Excel 2016. Search has yielded only custom toolbar ...
0
votes
2answers
23 views

Sum row/cell values when multiple column conditions are fulfilled

I'm want to sum every row/cell range in a table where one of (multiple) conditions is fulfilled in one of the columns. An example: I want to find the sum of all cells where the two (or more) ...
1
vote
0answers
25 views

How to switch which sheet another Excel sheet is looking at?

Excel (2016). Suppose I have some piece of Excel in AnalysisSheet that analyzes data in some other data sheet. And suppose the following: There are actually several such data sheets. For example, ...
0
votes
1answer
14 views

Find specific cells in column N, change value in column O

I am new to VBA coding and am trying to search for a name in column N and replace the value in column O. I have tried to modify this code but I cant get it to replace the cell next to it. Columns("N"...
0
votes
1answer
45 views

If formula contains specific text/symbol/function

How can I detect if certain cells contains specific formula with specific text/symbols? 1. A formula which is =today(), or =date(), or =time() 2. A formula which starts with =(any alphabet letter) 3. ...
0
votes
1answer
13 views

Is it possible to link 2 different cells to a ComboBox in Excel?

I have a ComboBox that's linked to a cell, R2. It outputs whatever value is entered into it in R2, but what I'd like (if even possible) would be to have the ComboBox output the value to two different ...
0
votes
0answers
8 views

Excel formulas referencing cells within a range of data do not update when that data is sorted or filtered

After an hour of searching Google, the closest similar problem I could find to the issue I'm experiencing is the following linked post on this site. However, a viable solution for my application was ...
1
vote
1answer
55 views

Excel 2016: 3D column chart with transparency and no gap

I'm trying to make a decent-looking chart using a 3d representation of three different datasets (3 years, 12 monthly values). If I try with an area chart, I have peaks/valleys at the single data-...
0
votes
1answer
47 views

How to format big numbers to show million separator in Excel?

Given the following number 11452610,20 (11452610.20), I would like to format it like that: 11.452.610,20 (11,452,610.20) I already tried to check "Use Thousands separator" but it only shows as 11452....
0
votes
0answers
6 views

return value (date) from most recent closest value

I am tracking daily balances from two accounts. Each row has a date in Column B. Totals for account balance is in Column O. I would like to return the corresponding date value in Column P from Column ...
0
votes
0answers
10 views

Aligning scatter points to non-stacked bar charts for multiple series

I am trying to create a combination non-stacked bar and scatter plot, where the scatter plot is aligned to the top of the bar chart. My issue is I am comparing two data series for each identifier, in ...
0
votes
1answer
13 views

How to lookup for NA value in Excel?

I have two sheets: Contains form number and amount Contains bill number and amount I tried to reconcile which bill belongs to which form using simple lookup based on the amount, ignoring duplicate ...

15 30 50 per page