All Questions
Tagged with microsoft-excel-2016 spreadsheet
18
questions
1
vote
1
answer
30
views
Plot data set as an chart in Excel, and then add a second series showing the data's multiple standard deviation bands aligned to data values
I am working with a time series set of data which is the Rate of change between successive price changes in a historical section of a stock price. I have 59 observations. I have also calculated their ...
- 15
1
vote
1
answer
69
views
Coloring cells across multiple excel sheets in an xls file based on a condition
I am new to excel. I have an xls file with 10 sheets. In each sheet I have two tables of size 10 x 10, one starting at position A4 and the other starting at N4. All the entries are numbers.
(Note that ...
- 113
1
vote
1
answer
200
views
Drag to fill duplicates values
I want to create a sequence of dates that populate a column.
A
2023-12-31
2023-12-30
2023-12-29
...
Format Cell is set to Date.
Calculation Options is set to Automatic
Enable fill handle and ...
- 393
3
votes
1
answer
242
views
Filtering over merged downwards cells in MS Excel-2016
Note: This question has been asked back in 2010 on this site here. And yet, I would like to post it one more time, showing what I did and what didn't work. Besides, Excel has changed quite a bit since ...
- 131
0
votes
0
answers
34
views
Sorting an excel column with numbers and keep track of cell indices
So, this is my problem, I have two excel columns like :
1 // 0.5
2 // 3.3
3 // 1.2
I would like to sort the second column in ascending(or descending) order, and also change the first column as ...
- 1
0
votes
1
answer
14k
views
Excel: How to show a floating text box only when I select the cell?
There's a type of text box in an Excel file that is associated with a cell
and appears only when you select that cell uniquely
(e.g., by clicking on it or moving to it with cursor keys).
Hovering ...
- 13
0
votes
2
answers
150
views
How to write an Excel Formula that takes a total across multiple repeating rows [duplicate]
I'm working with payroll data in a spreadsheet. What I'm looking to find is a total across different rows of employees with different roles. For example, how could I write a forumla for the "...
- 1
0
votes
1
answer
2k
views
How would I copy an Excel sheet that has formulas with "Table2[Date].." to a new sheet?
I created a sheet that uses several tables. There are many formulas that reference different rows of different tables on the same sheet. The sheet was for the month of Feb. I want to copy the format ...
-1
votes
1
answer
4k
views
How to automatically update all the relevant cells in Excel when a new row is added
So I have a spreadsheet used for calculating let's say the taxes on something which I purchased. It has a column with the sales tax calculation, state tax, etc. and all each of these columns reference ...
- 1
1
vote
2
answers
2k
views
MS Excel - Separate text based on keyword
I need to separate text based on a keyword to different columns. the original text is in one column but I want to split the intended subtext into different columns. The problem in this case is I get ...
0
votes
2
answers
793
views
Excel - If any of 6 cells are > 0 divide by that number of cells
What I'm trying to do is the following:
Once 'Cell B19:B20' and 'Row 21' have a value, 'Row 22' divides 'Cell B19:B20' between the amount of columns that have a cost value ('Row 21').
For example:
...
- 3
0
votes
1
answer
17
views
Quick way to change between no auto formatting and auto formatting in Excel
I'm looking for a method to quickly switch between an Excel state that disables all auto formatting (for ETL work) and the standard state with standard auto formatting enabled.
There are many posts ...
- 3
2
votes
1
answer
855
views
A single pound sign '#' to custom format excel cell?
I need to display a very big number within Excel, for example a following number: 174587584558159.
Excel displays it by using a scientific notation, like following: 1.74588E+14.
I tried to format ...
- 121
0
votes
1
answer
1k
views
Updating column values from one Excel spreadsheet to another
I had no idea what to Google for this. Basically I have 2 Excel files: File A and File B.
Here is File A:
And here is File B:
I am trying to loop through File B. I want to look at each row's first ...
1
vote
1
answer
9k
views
How do I pull data from one cell to another using matching info in excel? [duplicate]
So, let me try to explain what I need. I have two different workbooks of data. I need to match info from "WB1 Column B" to "WB2 Column A". If there is a match, I need to pull the info from the same ...
- 11
0
votes
1
answer
10k
views
Comparing two Excel spreadsheets to highlight changes
I need to compare two large, multi page spreadsheets and combine them into one spreadsheet showing the data that was in the original one and also what it was changed to in the second one?
I have ...
- 11
0
votes
1
answer
202
views
Ticket report - Auto populate from other worksheets into specific form
Hello ladies and gentlemen, I'm quite a dummy in excel and programming in general and I have a question related to building a report:
I must present a ticket report of which tickets are opened, how ...
5
votes
3
answers
92k
views
Put a checkbox in a cell in Excel v15 for Mac
I am trying to make a checklist in Excel.
Basically I am trying to make a cell:
Into a checkbox that can be checked or unchecked, and saved with the spreadsheet:
It's super-duper easy to do it in ...
- 222