Questions tagged [microsoft-excel-2013]

The 2013 version of Microsoft's spreadsheet application.

Filter by
Sorted by
Tagged with
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 ...
Jonas Heidelberg's user avatar
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 ...
Achyutha Mohan's user avatar
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 ...
S Wms's user avatar
  • 1
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 ...
buzz's user avatar
  • 3
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 ...
Steve can help's user avatar
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 ...
user684273's user avatar
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(...
Julien's user avatar
  • 1
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 ...
Kendall Lister's user avatar
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)...
Albert's user avatar
  • 11
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 ...
Todd H.'s user avatar
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 ...
C.J.'s user avatar
  • 1
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?
PpiucdPk's user avatar
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
spicepk's user avatar
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 ...
igorbogu's user avatar
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 ...
Bo Stackhouse's user avatar
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 ...
Kendall Lister's user avatar
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";"...
рüффп's user avatar
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 ...
Roman's user avatar
  • 1
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 ...
Domorodec's user avatar
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 ...
Kevv's user avatar
  • 29
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 ?
Parth Bhimani's user avatar
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) ...
Exhausted's user avatar
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, ...
Lindsey's user avatar
  • 13
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-...
PPC's user avatar
  • 736
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" ...
Exhausted's user avatar
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 ?
user avatar
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 ...
Ben Hamilton's user avatar
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 ...
sikrut's user avatar
  • 11
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)?
Thurein's user avatar
  • 113
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 ...
Lion Prince's user avatar
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 ...
Exhausted's user avatar
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 ...
jroyce's user avatar
  • 128
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 = ...
Exhausted's user avatar
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 ...
Kendall Lister's user avatar
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 ...
Kendall Lister's user avatar
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 ...
Birdie's user avatar
  • 113
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 ...
Yamur's user avatar
  • 131
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 ...
Zizoo's user avatar
  • 123
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 ...
Benedikt Buchert's user avatar
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 ...
D. Ashley's user avatar
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 ...
JackOfTales's user avatar
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 ...
Mohamed Ibrahim's user avatar
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 ...
Exhausted's user avatar
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.
meredith helms's user avatar
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 ...
Sardar_Usama's user avatar
  • 1,833
-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 ...
Judd Lehmkuhl's user avatar
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 ...
Charas's user avatar
  • 135
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 ...
Dirk101's user avatar
  • 37
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 ...
Phillip's user avatar
  • 21
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 | +-...
Charas's user avatar
  • 135

1
9 10
11
12 13
33