Questions tagged [microsoft-excel-2013]
The 2013 version of Microsoft's spreadsheet application.
1,614
questions
1
vote
1
answer
167
views
How many entries can autocomplete in Excel 2013 handle?
When typing a text entry into a cell which already exists in a row above, Excel supports autocomplete (while you type), so you only need to type "al" to get "alpha":
My question is:
How many lines ...
0
votes
1
answer
37
views
How can I get a section of the data present in the format shown below?
I have the following columns of data:
Month Mat Plant
Jan x p
Jan y q
Feb x p
Feb z r
Mar x p
Mar z s
Apr y q
Apr z s
Then in a ...
0
votes
2
answers
2k
views
Formula to do one calc if a cell is blank and a different calc if the cell has a value
Unlike a basic IF statement, I need Excel to calculate one formula if a designated cell is blank but a slightly different formula if the designated cell has a value higher than 0.
If an existing ...
0
votes
1
answer
5k
views
How to insert a line break in chart Y-axis custom labels in Excel 2013?
Is there any way to create a custom number format that includes a line break for chart Y-axis labels in Excel 2013? The zero-label in my chart is very wide and I would prefer that it broke over two ...
0
votes
1
answer
3k
views
Excel 2013 & VBA > Count number of conditional formatting rules on sheet
Excel has a limit of the number of conditional formatting rules a sheet can handle before it locks up and prevents any more from being added. This can become an issue in complex sheets where one or ...
1
vote
1
answer
25
views
Excel 2013 issue when trying to import file
I downloaded a file to work on in excel. The file is supposed to consist of 3 different columns of data, but when I open the file in excel all 3 columns of data are loaded into a single columns. How ...
0
votes
0
answers
939
views
Power Pivot - Count cells that contain specific text?
I keep trying but I would appreciate some help.
How do I do this https://exceljet.net/formula/count-cells-that-contain-specific-text
But with a PowerPivot?
I need this but in Power Pivot: =COUNTIF(...
4
votes
1
answer
30k
views
How can I get the number of rows in an Excel pivot table for use outside the pivot table?
I have a pivot table in Excel of the form:
Country Server Status
Australia AU1 1
AU2 1
AU3 4
New Zealand NZ1 4
NZ2 ...
1
vote
0
answers
61
views
=IF() Not working properly in some rows MS EXCEL2013
Can Someone help me with this formula because some rows are working properly and some rows are not such as this one in the image i shared. its says failed even though m266 and d266 is the same (400.00)...
0
votes
1
answer
72
views
Excluding 0 results from being Conditionally Formatted
I want to conditionally format a cell as one color for a result that is above 40% of another cell & exclude the 0 results from being formatted. I can achieve the 1st part with =(c301*.4) as the ...
0
votes
1
answer
1k
views
Excel 2013: Extract multiple rows from spreadsheet based on column of unique IDs
I have two spreadsheets:
The first contains a large amount of data on research projects. Each project has its own unique ID, listed in the first column of the spreadsheet. However, these IDs are ...
0
votes
1
answer
52
views
How to find unique count of clients who have TimeFollowUp = "6 Months" and TimeFollowUp Not Equal to "6 Months"?
How to find unique count of clients who have TimeFollowUp = "6 Months" and TimeFollowUp Not Equal to "6 Months" in MS Excel?
0
votes
0
answers
46
views
Recover password from spreadsheet [duplicate]
I set a password on an Excel 2013 spreadsheet but now I don't remember it.
Is there any way that I can remove or recover it? It is an .xlsx document
1
vote
1
answer
650
views
Importing data from SQL to Excel adds apostrophe to string that begins with "="
I use MySQL for Excel, and I am trying to import data from MySQL.
One of the cells (fields) in MySQL contains the following string:
='WW24'!E7
Excel, by default, adds an apostrophe at the beginning ...
0
votes
1
answer
32
views
Can I make cells fill in only after something is on the same line in Excel 2013?
I am trying to make a spreadsheet in Excel 2013 that if data is entered on a line then the cells that don't have data in that line become highlighted.
I don't want to have the whole spreadsheet to ...
1
vote
1
answer
13k
views
Why does Ctrl-Down Arrow in Excel take me to row 1048576?
When I use Ctrl-Down Arrow in Excel 2013 (as described in Go to last line with data, Excel 2007) I am taken well past the last line of data (about 1700 rows) all the way to row 1048576 - why might ...
2
votes
0
answers
2k
views
Is it possible to make Excel auto-filter case sensitive?
I have a CSV file I opened with Excel 2013 because I wanted to find errors in a specific column.
Here is an extract of data:
"ID";"LANGUAGE";"TYPE";"NAME";"ACTIVE";"CITY";"POSTAL_CODE";"...
0
votes
2
answers
4k
views
Excel: Use cell reference within formula for formula in another cell
I have joined just to ask this question as I'm not sure if it's achievable without VBA.
In column A I have a list of values, let's say A1:A9 contain the values "1000" to "9000" respectively.
In B1 I ...
0
votes
2
answers
53
views
MS Excel 2013 - finding and replacing data
I have business task and I really don´t know how to deal with it. I have table of data e.g.
A B C D Result
2021 5044 NEMR 5038 ?????
and I need to put into cell "result" this: find ...
1
vote
1
answer
123
views
Excel How do I list the options of a filter in a cell?
We have an Excel sheet with a filter on a specific column. The values in the filter for this column are "Purchase" and "collection".
I want my users to be able to choose 1 of these 2 options in this ...
2
votes
1
answer
593
views
select every 3rd number from the excel column
I have a excel worksheet with the one column (9000 value) and i want to have every 3rd value of the column. Or is it possible to have a command which gives the average of every 3 value ?
0
votes
1
answer
3k
views
Excel date to day from sheet name
I'm using this code to grab the sheet name and put it into cell C2.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
I would like cell C1 to display the correct day of the week (ddd) ...
1
vote
1
answer
19k
views
How do I change where the secondary axis data is plotted in Excel chart?
I have an Excel chart with two vertical axes; Dollars on Primary and Claims on Secondary, and Date Range horizontal. For each date range there are three organizations I'm comparing between (MaineCare, ...
0
votes
1
answer
874
views
Excel chart : how to *not* scale to numeric values on X
I would like a chart with dates on X, displaying those dates but not scaling to them
Here's a data table with values on Y and dates on X
Date Value
2016-10-01 10
2016-10-02 15
2016-12-...
0
votes
1
answer
500
views
Conditional Formatting not working with formula
I'm using the below formula to input the name of my excel sheet into a cell. When i try to use conditional formatting on that cell and use the option "use a formula to determine which cells to format" ...
0
votes
1
answer
35
views
How do I instruct Excel to sum products of cells automatically?
In other words, how do I instruct Excel to calculate the sum in A1, WITHOUT any need to
compute firstly (in a separate new column) cn = an*bn
and to instruct secondly Excel to sum all cn ?
0
votes
1
answer
1k
views
Extra columns in a pivot table
I have a pivot table in Excel 2013 and am breaking down customer records by ethnicity and the number of deps (children) they have:
I want to add additional columns to look at how many of each ...
1
vote
1
answer
7k
views
Why won't Excel autofit my row height? [Microsoft Excel 2013] [duplicate]
[Microsoft Excel 2013]
This row looks like it should auto fit to the height of just 1 line, but autofit is not working here. I've checked and there are no merged cells, and I've even disabled wrap ...
1
vote
1
answer
945
views
How to use PowerPivot in Excel 2013 (Home and Business)
Is there anyway to use PowerPivot in Excel 2013 (Home and Business)?
0
votes
1
answer
93
views
Excel Pivot Table Can't Access Average of Rank
In regards to making a Pivot Table. When I'm trying to use the Top 10 filter, I am unable to even see the option for Average by Rank, only Sum of Rank. What is preventing me from being able to select ...
2
votes
1
answer
503
views
Excel - Merging two =COUNTIF functions into one cell with a standard formatting character between
Merging two =COUNTIF functions into one cell with a standard formatting character between each.
I have two functions that i want to display the data in one cell with a slash "/" between the data. How ...
5
votes
5
answers
11k
views
Error while saving a shared Excel spreadsheet: "Errors were detected while saving...."
I get the following error on my shared Excel spreadsheet when saving:
Errors were detected while saving "\server......\ Microsoft Excel may be able to save the file by removing or repairing some ...
0
votes
2
answers
87
views
Counting data in excel cells [closed]
Im trying to create 2 formulas in excel to count the number of times data has been inputted.
The following 2 cells will contain the number of departed and returned vehicles.
T1 = Departed T2 = ...
4
votes
2
answers
31k
views
How can I display a UTC date time value in the user's local time zone in Excel?
I have a spreadsheet with date/time values in UTC that I would like to be displayed to users in their time zone, e.g. the same spreadsheet containing UTC date/time values is provided to users in ...
3
votes
1
answer
15k
views
How can I remove the expand/collapse buttons for only some fields in an Excel pivot table?
I have a lot of pivot tables populated from SSAS cubes. Some have expand/collapse buttons for only some of their fields (not the first or second field but then for every other field).
I know how to ...
0
votes
1
answer
6k
views
MAX function always returning 0 in a range
I have a column A, such that the first row value is 1, and the second row value is:
=MAX(IF(A1:A2<>"";A1:A2))
This displays a 0 in A2; why doesn't it show 1, as 1 is the maximum of the range ...
0
votes
1
answer
371
views
How can I map data point in XY axis?
I have a single data points as below.
First data point = 0.3,
Second data point = 0.2,
Third data point = 0.5,
Forth data point = 0.6
I want to map these points in XY coordinates as Cartesian ...
1
vote
1
answer
125
views
How to get value of cell only if it is not containing any number ? - Excel
I'm using Excel version 15.27 on Mac and I want to get value from first column cells (A) and adding it to the last column cells (D) only if the cell from column A doesn't contains any number .
For ...
0
votes
2
answers
222
views
How do I list all values in 3 different columns in a new column?
I have three seperate columns with values in an Excel Sheet. Now I want to create a new column that concatenates all values from these columns. When I add new values to one of these three columns, I ...
0
votes
1
answer
79
views
If then statement using trailing 12 months over multiple spreadsheets
I am trying to create a formula for:
If(the trailing 12 month sum is equal to $250,000, then add a sales rep,0)
where the trailing 12 month data is contained in multiple worksheets and broken down ...
1
vote
2
answers
5k
views
No more [Blanks] option on Automatic Table Filter in Excel
I'm running into an issue that I do not know how to fix. I have a spreadsheet with an excel table. The automatic filter at the top of one column is no longer allowing users to select (blanks) as an ...
1
vote
1
answer
84
views
Update data automatic
I have a sheet which contains column for transactions date, transaction Ids, and transaction status.
I want to update status of the transaction Id daily automatic according to the date I will give ...
0
votes
3
answers
124
views
Joining 3 Excel IF Statements
I'm trying to join the following 3 IF statements in Excel but every time i try i get an argument error or else it reverts back to displaying "True" or "False" instead of "Miss Window", "Hit", "Not ...
1
vote
1
answer
32
views
excel 2013 save files correctly in a CSV format. Numbers come up as text and produces incorrect totals
not able to completely save files correctly in a CSV format. Numbers come up as text and produces incorrect totals. We had several people on the team try and we are all having the same issue.
1
vote
1
answer
1k
views
How to make an office file always open in Protected View?
Usually when office files (e.g docx, xlsx, pptx etc) are downloaded from the internet and opened, these files open in Protected View.
How can I set the default setting of a particular local document ...
-1
votes
1
answer
67
views
Excel Formula help please If match copy vale form cell
I am trying to update a stock list,
Column A = Barcode Column B = Correct Qty
Column C = Barcode Column D = Incorrect Qty
So i need a formula that if Column C is matched to Column A ...
1
vote
1
answer
3k
views
Microsoft Excel how to select all cells that meet certain condition (i.e greater than a value)
I am using Microsoft Excel 2013, and I want to select all cells that contain the value that is greater than a value. How do I do this ?
I have tried using Go To Specials, but it seems it is only able ...
0
votes
1
answer
3k
views
Plotting daily values and weekly averages in the same chart
I have a simple data set of weight values per day, the DAY data set:
Date Weight
1/11 61.3
2/11 61.9
3/11 62.2
4/11 61.5
[...]
I want to plot this on a line chart, together with a second line ...
2
votes
0
answers
130
views
How to compare fields in Pivot Table
I have a very very large amount of data that I need to analyze in Excel. 1 million rows by 10+ columns. I have huge problems regarding processing time when I copy down formulas to make comparisons ...
2
votes
1
answer
75
views
Microsoft Excel how do I convert the first row into column and then sort the rest of the rows according to the first column
For Example I have this data:
+------------+--------+
| 01/11/2016 | Data 1 |
| 01/11/2016 | Data 2 |
| 01/11/2016 | Data 3 |
| 02/11/2016 | Data 4 |
| 03/11/2016 | Data 5 |
| 03/11/2016 | Data 6 |
+-...