# Questions tagged [microsoft-excel-2013]

The 2013 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

48 views

### Complicated 'IF' function in Excel

In Sheet 1, I have the following:
If the Due Date is after the Date Submitted, then I want the value in column D of this sheet to be the Detail Status, which is on Sheet 2,
UNLESS the Detail Status ...

**0**

votes

**0**answers

16 views

### Excel: Find values in Column B or C and display corresponding Column A values

I have a large excel data set, sample below:
Name City1 City2
User1 NYC LAX
User2 LAX CHI
User3 SFO NYC
User4 CHI SFO
I would like to create pivot tables (1 table/...

**0**

votes

**1**answer

26 views

### Select user id for every date in excel

I want to select user id for every date in excel. Tried doing this =IF(A2=A1,(IF(B2>=B1,E1+1,0))) but not getting the exact expected result
Input
user_id date
10003 12/19/18
10003 12/19/18
...

**0**

votes

**1**answer

28 views

### Find quantity sold of particular size over time

I have a spreadsheet where I am recording sales of shorts over time. I have been using it to keep a record of who buys them, what date, what size and how many pairs they bought. I'm hoping to expand ...

**0**

votes

**1**answer

65 views

### Excel 2013 - Why are some blank cells acting as “0” and other blank cells acting as “”?

The formula I'm using in column J is =IFERROR(IF(B1>0,H1*I1,""),""). In columns H and I, most of the entries are blank (not zero), and J calculates 0. In row 23, J changes to calculate "" while B is ...

**0**

votes

**2**answers

127 views

### Automatically duplicate pivot column, but exclude certain values?

I have a column that I would like to duplicate onto a new sheet. The column can be filtered:
I want to duplicate everything in this column except for the 'Approved' cells (1st option in the drop-down ...

**0**

votes

**0**answers

12 views

### EXCEL Spreadsheet filtering [duplicate]

I have a data table with images. When I filter the pictures are still visible stacked on top of each other.
How do I set up the sheet so the images associated with the row I am filtering out are ...

**0**

votes

**0**answers

12 views

### Repeat header at grouping level in excel

Is it possible in excel to split a table data based on a specific column/group? Main goal is to repeat header at group level. Getting Row2 and Row16 is good to have, but not necessary.
Would this be ...

**0**

votes

**1**answer

25 views

### select previous row of particular event in excel

I am current working on a problem.. where i need previous event of applaunch in excel
Input
notification_dismiss
notification_dismiss
notification_dismiss
AppLaunch
...

**0**

votes

**3**answers

43 views

### Select 1st day of each user id in excel

Trying to figure out away to get the expected output from the id and date columns. How do i select 1st days of each user id .. the formula i tried is this IF(A2=A1,(IF(B2>B1,FALSE))) but not getting ...

**0**

votes

**1**answer

28 views

### Excel: Add multiple tables into a single stacked column graph

I have been asked to make graphs of some evaluation forms, however I don't see how to make readable graphs with the data they gave me:
Every group has its own little table with data, the graph they ...

**1**

vote

**0**answers

19 views

### Excel VBA to merge files [closed]

I have a template that I fill with information for a group of 10 agents. After they work on them i end up compiling them in a single file and im looking for a VBA code to automate this task.
Each ...

**0**

votes

**0**answers

24 views

### VBA - Excel Stops Responding - Table Applied to Whole Sheet?

I have a button that calls many separate macros. Everything works as expected, but with 1 exception.
I need to input a formula in row 2 of four separate columns and have the formulas drag down to the ...

**9**

votes

**5**answers

3k views

### Combining first two letters from first name and first two letters from last name

I have a spreadsheet of usernames.
The first and last names are in the same cell of column A.
Is there a formula that will concatenate the first two letters of the first name (first word) and the ...

**2**

votes

**1**answer

29 views

### Delete all rows not containing xxxx

I found and modified the below code to remove all rows that don't contain "NHO_Global" in column F, but it deletes everything (it does leave the header row, though).
What did I do wrong and how can I ...

**0**

votes

**0**answers

6 views

### How to update a cell in another sheet after printing an invoice in 1st sheet

I want to increment a cell value whenever the sheet is printed. But the twist here is that the cell, which has to be updated is in a different sheet but in the same document. Please let me know, if ...

**1**

vote

**1**answer

51 views

### Cell conditional formatting, based on the format of the same row's cells of another column

I've highlighted my duplicate text in column B, using Conditional Formating. No I want to highlight the same field on column A (and afterwards delete all non highlighted texts), but I am not sure how ...

**0**

votes

**2**answers

76 views

### how to move decimal and comma points in excel?

i have a .txt file, where i have numbers such as-
99.69599
100.7113
101.7196
123.93
but whenever i am exporting them to excel, they become like this-
9.969.599
1.007.113
1.017.196
123.93
...

**-1**

votes

**0**answers

22 views

### Making two columns equal in Excel

I want to make two columns in an excel same means that if one column's particular data changes then it should also reflect in other column.

**0**

votes

**0**answers

24 views

### VBA - Assigning Macro to Form Control Button

I wrote the below code in VBA to delete full rows if, in column U of Sheet21 (actually named "ROG Registration") if "Self Cancelled" or "Waitlisted" appear. When I'm on the ROG Registration tab with ...

**0**

votes

**1**answer

41 views

### Excel 2013 chart - setting time intervals in vertical axis

I have time (mm:ss) in the vertical axis of a bar chart.
I want to set the following parameters:
min - 0
max - 12:00
major ticks: every 2:00 min (0, 2:00, 4:00, etc.)
minor ticks: every 0.5 min (0:...

**0**

votes

**0**answers

33 views

### VBA - Filling sequence from 1 to N

I'm not sure the title is clear, but essentially what I need is to automate the assignation of sites. The number of rows is usually around 60, but could go up to 200. The assignation of site number ...

**-1**

votes

**0**answers

9 views

### Is there an option in excel, to automatically jumb to the other names if a name is already used in the same column?

I am trying to make an excel format in which, column A represents the operation name say operation 1; column B represents the name of best efficient operator for the particular operation; column c ...

**-1**

votes

**2**answers

95 views

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

I am looking for formula to search for "words" 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. The words are always ...

**0**

votes

**1**answer

79 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

37 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

44 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

30 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

23 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

12 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

62 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

62 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

18 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

61 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

27 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

35 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

85 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

34 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

51 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

75 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

23 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

59 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

35 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

141 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

52 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

65 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 ...