# Questions tagged [microsoft-excel-2013]

The 2013 version of Microsoft's spreadsheet application.

**-3**

votes

**1**answer

35 views

### Looking for formula to search for particular pattern in Excel

I am looking for formula to search for a "word" with a particular letter pattern, like INNSA1 or INMAA4 or INPTPB, where the word starts with IN and ends with 4, 1, 6, or B, in a sentence in an Excel ...

**0**

votes

**1**answer

38 views

### Transpose Stacked Data in One Column to Rows based on Variable Criteria and Unique Identifiers

Using Excel 2013 and I'm struggling to write a formula that allows me to transpose the amounts stacked in column E based on the deduction code in column F using various criteria on the first row/...

**0**

votes

**0**answers

36 views

### How to replace a column of numbers with a numbered column?

I got our new timetable for the new course, the thing is that it's actually two excel spreadsheets; one with the number of the lecture and the time, the other is the title of the lecture. So if want ...

**0**

votes

**1**answer

17 views

### Excel: COUNTIFS or Nested IF counting sequential columns

this is my first time posting here so please be a little patient with me. I'm trying to write a formula that will tracked missed scan events (for a package tracking database).
I have several date/...

**1**

vote

**2**answers

36 views

### Convert text of numbers to date and time

the output I get for date and time from my database is like this: 20181003134521. The format is yyyymmddhhmmss. This would be in actuality 10/03/2018 13:45:21. What formula in Excel can I use to ...

**0**

votes

**1**answer

29 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

**1**answer

22 views

### Get the name of the column of a largest number in an Excel array?

I have a data set with numeric values, from which I need to get the name of the column in which is located the largest number, row by row. Please see below (I'm omitting the columns names for ...

**0**

votes

**0**answers

8 views

### XLS2013: FindAll=> SelectAllCells=> SelectAll (Rows or Cols)

I used to be able to:
FIND BOX...
FINDWHAT: xyz
FINDALL: RC lists of cells containing 'xyz'
SELECTALL: click 1st found cell; shift click last found cell
Close FIND BOX
SELECT ROW Command: ...

**0**

votes

**1**answer

11 views

### Excel 2013 Scale to Fit Page by Page Breaks

QU: Is there a way I can have 'shrink to fit page' work on blocks of rows independently?
Details: I have a spreadsheet with blocks of data for each day of the year, with about 50 rows each, and I ...

**0**

votes

**3**answers

51 views

### Use LEFT in sum_range parameter of SUMIF function (Excel)

I have a lot of columns on top of each other, like so:
I would like to find all of the cells in this range that begin with 1a, and then sum up whatever follows. So in this example, we find 1a10 and ...

**1**

vote

**0**answers

59 views

### Excel: why do “remove duplicates” and “conditionally highlight duplicates” give different results?

Obviously these tasks do different things! But I am using them to find out if I have duplicates :)
In excel I have a column which is a concatenation of all of the other columns.
(The formula is ...

**0**

votes

**0**answers

17 views

### Excel 2010 on Windows 10 does not save changes

I got reports from Excel 2010 and 2013 users that they open some Excel document, make changes (add, delete or update), save the document and then probably send it through Outlook. The problem is when ...

**4**

votes

**0**answers

56 views

### Excel 2013/2016 not updating values while workbook is minimized

I have the following setup:
1 Workbook named Workbook1 with the value 123 in A1
1 Workbook named Workbook2 with value =[Workbook1.xlsx]Sheet1!$A$1 in A1
Now, when I go and change the value of ...

**0**

votes

**0**answers

25 views

### Excel automatically changes font in a cell after text input

I have an Excel sheet (in Excel 2013, xlsx format) with a table in the first 10 rows. The first column of this table (and it's 10 rows) has font set to Arial/Bold/10. All rows have some data in it.
...

**0**

votes

**1**answer

22 views

### How to set auto sort on two columns when open the workbook?

I have a workbook that we run for weekly reports, however daily we are adding new records also.
Now, I want to know that how could I set auto sorting on two specific columns every time I open the ...

**0**

votes

**1**answer

61 views

### Excel Workbook - ownership request prompt to the editing user

I have a workbook file that is used by 1 team with a few people; but soon it will be disparate teams (2 teams; 8 people) accessing the file on our corporate share... This could grow to more teams and ...

**3**

votes

**3**answers

33 views

### Add only working days in grid style using Microsoft Excel

I like to have a calendar date view of the five working days in Excel.
I manually built a first row with dates from 30th July 2018 to 3rd Aug 2018 (Mon to Fri, which are working days) and a second ...

**1**

vote

**2**answers

46 views

### Is it possible to protect the structure of an Excel sheet without protecting the contents?

We want to protect the structure of an Excel sheet (the user should not add or remove columns or change the format of the cells) but allowing him to change cell content and adding or removing rows.
...

**0**

votes

**1**answer

35 views

### How to combine two First Name with and followed by Second Name?

I've huge list of Couple's Name and I want to reorganize the list.
Check the Screen Shot:
Below is the Formula I've applied:
=LEFT(E48,FIND(" ",E48&" ")-1) & IF(ISNUMBER(FIND("and",E48))," ...

**-1**

votes

**2**answers

71 views

### Can Excel Pivot Tables delimit data and perform calculations on the data?

I'm trying to create a document for work to track a lot of information and provide feedback based on the inputs. I have nearly everything I need complete, except the results that occur. I have ...

**0**

votes

**0**answers

17 views

### Excel 2013 Hide Page Breaks by default in Normal View

I exclusively use Excel 2014 in Normal view, and I never ever use the dotted page break lines. I know I can turn them off with File > Options > Advanced > Uncheck "Show Page Breaks." I want this to be ...

**1**

vote

**1**answer

56 views

### Fill multiple columns in excel with data from other sheets with one formula

Excel newbie here. I have 3 excel sheets.
Sheet 1 contains data in columns A and B, sheet 2 contains data in column A.
What I'm trying to do is enter a formula in sheet 3 such that columns A, B and C ...

**-3**

votes

**1**answer

31 views

### Microsoft Excel 2013 Column value [closed]

I would like to have my column in excel have a specific value. For example in column B if I type a 2 in row 2 and a 3 in row 3, I instead of the auto sum giving me 5 I want it to give me 50 is there a ...

**0**

votes

**1**answer

32 views

### What is the Excel Popup from F2 in ready mode?

I stumbled on this behavior in Excel: pressing F2 (without any shift key) opens a slider bar that fades in a few seconds. At first I thought F2 editing was broken, but I see this only happens in Ready ...

**0**

votes

**1**answer

59 views

### Copying Chart to Another Sheet with Updated References in Excel

I have made a chart within a sheet in Excel. Within the sheet, the chart refers to specific cells in the sheet to display (i.e. cells that contain my data points).
I would like to know how to copy ...

**1**

vote

**1**answer

45 views

### Excel MIN with nested IF statement — Trying to ID a date closest to 30 days after a date

I have 16K plus records with an Auction Date. I need to find the date and amount that is closest to the Auction Date BUT more than 30 days later.
I have calculated a row that shows the difference ...

**1**

vote

**1**answer

48 views

### Pass or Fail in Excel [closed]

I want to compare the score in multiple columns against a fixed number to give a pass or fail for each column and overall i.e if one column is a fail, the whole series is a fail.
For example each ...

**1**

vote

**1**answer

35 views

### Assign Nested Sequential unique numbers for items in Excel Table

I'm trying to generate a unique ID number for a items in a table in excel.
For example: 1.2.4
For each column the number is uniquely numbered based on the text.
For example in the table below would ...

**1**

vote

**0**answers

32 views

### Can't get rid of custom styles in an Excel 2013 workbook

I use Excel 2013 and I am trying to clean up an 8000 KB spreadsheet which has evolved over the years to include thousands of duplicate cell styles.
I managed to get rid of most of them using some VBA ...

**1**

vote

**1**answer

42 views

### How to implement this formula with braces and brackets into Excel

I'd like to use Microsoft Excel to compute this formula to find y :
But I absolutely don't know how to do... It's the first time I see such one.
Could you help me ?
Note : Td2 is a known variable ...

**1**

vote

**3**answers

124 views

### Can Excel VBA call Macro in Different Macro Workbook

Can VBA code in an excel spreadsheet call a different XLSM Workbook file's Macro?
I have a local XLSM that needs to call a method in a different XLSM file, how can that be done?

**0**

votes

**0**answers

13 views

### Excel 2013 Slow to open over FTP

I have a user who's opening a 2 MB file over our FTP network. It takes the system about 40 seconds to open it after the password (set through standard Microsoft file encryption no macros or add-ins ...

**3**

votes

**1**answer

135 views

### Counting pairwise combinations from many options in Excel

I have a large dataset of students and the classes they have taken. Each student has taken 12 to 18 of around 80 available classes. Using Excel (2013) I would like to find out, for any given pair of ...

**0**

votes

**0**answers

40 views

### Excel spreadsheet with max rows/columns that won't delete

I have an excel spreadsheet that has more than a million rows and thousands of columns (maxed out on both axis).
Whenever I delete the row at the end (1048576)it comes back.
If I delete any number ...

**0**

votes

**0**answers

55 views

### Pivot table not updating available columns from data model source

I have four tables in an Excel 2013 workbook generated from four different ODC files.
Using Power Query, I added all four tables to the Data Model and created a common list in a query. I created ...

**1**

vote

**1**answer

19 views

### Excel Unable to Display or Distinguish Text Strings

I created a simple CSV file with only this exact text (quotes included):
"-2**31-1","-2**31"
How can I open this CSV file in Excel and get it to display exactly:
A B
1 -2**...

**1**

vote

**1**answer

69 views

### Cartesian product in Excel 2013

I have an excel in this format.
+----------+-------+---------+--------+--------+
| TicketId | PubId | PubName | Model1 | Model2 |
+----------+-------+---------+--------+--------+
| 1234 | 12 |...

**0**

votes

**0**answers

94 views

### Dealing with missing data in excel

I have an Excel 2013 Line Chart. The Horizontal (Category) Axis Labels are set to "2014", "2015", "2016", "2017", "2018".
I create multiple Legend Entries (Series) successfully, i.e. series with ...

**1**

vote

**0**answers

180 views

### Silenceing Excel 2013 Error “We couldn't free up space on the Clipboard. Another program might be using it right now”

I understand that the above error appears when there is a program installed which is incompatible with excel. I don't want to "fix" the underlying issue which is causing the error to popup, because ...

**0**

votes

**1**answer

78 views

### Excel Formula output error

As per below previous question link please find attached , formula is not giving output properly as if i need number inside the bracket only, hope any one can help enter image description here
Split ...

**0**

votes

**2**answers

137 views

### 'Merging Cells' in a table

I have an excel sheet that has a number of entities that are defined by their 'Job Number'. However, I need multiple rows per job meaning that the column ends up having duplicates, such as in
Is ...

**3**

votes

**1**answer

74 views

### Copying non-adjacent Excel rows/columns to a text editor?

I would like to manually copy data from non-adjacent Excel rows (or columns) and paste it into a text editor.
So far I haven't found a way to do this efficiently. (I'm using Excel Home/Student 2013.)
...

**0**

votes

**2**answers

63 views

### Split data into new column

As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket .
...

**0**

votes

**1**answer

24 views

### Additional Comments added to input

I have an excel file that was passed on to me and when I enter a number (say 154) in a cell it comes back with "comments = 154" where do i go and find where to delete that additional words. We thought ...

**-1**

votes

**1**answer

35 views

### Scatter plot for multiple rows

I'm trying to plot the following data in Excel using a scatter plot
Income 1960 1961 1962 1963 1964 1965
Algeria 1280 1085 855 1128 1170 1215
Argentina 5251 5448 5316 ...

**0**

votes

**2**answers

244 views

### Listing all unique values from table in another sheet

In Excel, I have a table where I want to list all unique values from a column in a different a row of a different sheet. Here is an example of the data I have:
I want to fill in cells in the other ...

**0**

votes

**1**answer

35 views

### Index match finding the first value only

I have a list of employees with duplicates and each employee has a number which represents the number of sales. I'm trying to use the following formula to extract the highest sale for a given name, ...

**1**

vote

**3**answers

986 views

### How to create a desktop shortcut to a Onedrive file

I would like to create a shortcut on my desktop to an Excel file located on OneDrive and having it open in Excel. (I'm using Windows7 and Office 2013)
Within Excel, I have retrieved the path to file (...

**2**

votes

**1**answer

151 views

### Dynamic row and column size for Text to Columns VBA code

I export CSV reports which often have around 200-5000 rows or 30-60 columns. Using the record a macro function I recorded a macro that goes through the Text to Columns Wizard, the resulting macro is ...

**2**

votes

**2**answers

115 views

### Excel formula for calculating days

I buy and sell different items. I am trying to write a formula that will work out how long an item stayed in stock.
For example:
A1 is Purchase Date, so I enter 1st June 2018
A2 is Sale Date,
A3 is ...