# Questions tagged [microsoft-excel]

A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

**0**

votes

**1**answer

27 views

### Cannot set MS Office 2013 as default even with editing registry

I have been struggling trying to set MS Office 2013 as default instead of 2007 ones. My work requires to have both of them in my PC so I cannot avoid having 2007 which I hate so much on my station.
...

**1**

vote

**1**answer

58 views

### Highlight the cells being compared in EXACT function in excel

I have an excel spreadsheet containing two columns.
I use the EXACT function to determine if, for example if A2.equals(B2).
The function returns true/false in another cell.
However, I am looking to ...

**0**

votes

**1**answer

37 views

### lookup with named range on separate sheet

I'm building a spreadsheet that has multiple named ranges on a separate sheet and I want to do a lookup to find the value based on the named range so I don't have to manually enter the cell references....

**0**

votes

**1**answer

44 views

### Is there a way to 'absolute' the referred or target cell?

Absolute references are not changed when the referring cell is moved. But even with an absolute reference, if the referred cell moves the reference is updated. I want it to be dumber and continue to ...

**0**

votes

**0**answers

19 views

### VBA 7.1 for macOS can only access /usr/lib when calling a function in a .dylib file?

Visual Basic for Applcations 7.1 for macOS reports
Run-time error '53': File not found: libMyFile.dylib
whenever I call a function in a dynamic library not in /usr/lib.

**1**

vote

**1**answer

30 views

### Excel VBA Macro - Copying data from multiple sheets in existing file, and creating new file and pasting selected data into separate sheets

any and all help is greatly appreciated.
Description:
I have an excel file with several sheets of data. I need to copy ALL of the data from multiple sheets, create a NEW excel file, and paste that ...

**0**

votes

**1**answer

17 views

### Using COUNTA and/or COUNTBLANK to show a sum of entries in two columns

Edit:
Current formula
To start, this is for my workbook that I have open throughout the day. One of my responsibilities to to periodically check another workbook for items added by the rest of my ...

**0**

votes

**0**answers

21 views

### Evaluate an Excel Spreadsheet in Python ( Headless Excel engine?)

So we have a manufacturing process that involves a fairly complex excel spread sheet (Actually several spread sheets) as part of the process.
Because the spread sheet is as complex as it is and it is ...

**0**

votes

**1**answer

29 views

### How to have Microsoft Word remember document passwords?

I am using the latest Microsoft Office apps on Windows, namely: Word, Excel and Powerpoint.
Word documents can have password based security. When you open a document, you have to input the correct ...

**0**

votes

**0**answers

34 views

### Run script after web query refresh. Can't get it to work

This is the code I have for the worksheet. It works if I type something into D32, but if the formula changes the number automatically it does nothing. What am I doing wrong? I basically have it set to ...

**-1**

votes

**1**answer

19 views

### parsing a list and creating columns in excel

I have a large list in which I need to identify on Titles and URLs each section in the list may have more information that I'm not concerned with. The list looks like Column B in the picture. I'm ...

**0**

votes

**1**answer

30 views

### Excel group transposed columns by date

I'm having trouble transposing data to get the format that I'd like. I have pay period end dates in one column and employee names in the other column, and I'd like format it so that each column header ...

**-1**

votes

**0**answers

27 views

### Calculate date when worker will be back from med license

I want to calculate wich date workers on medical licenses will be back (including local holidays and weekends), so for example I have a worker with a 8 day license starting on 4/15/2019 and cosidering ...

**-1**

votes

**0**answers

18 views

### Excel Cell Mandate on the basis of another cell

I would like to mandate a comment in column D, if user selects a value of 1 (out of a drop down list of 1,2,3) in column C. For example, if the user selects 1 in column C5, then the user must not be ...

**0**

votes

**0**answers

21 views

### Is it possible to create a static data table from GETPIVOTDATA?

I am trying to create a static data table to allow me to attach comments to individual lines to explain changes - if I simply put them against the pivot table, as soon as the data cube updates, the ...

**1**

vote

**0**answers

29 views

### Is there any way to keep MySQL code in one cell, while also keeping the MySQL syntax colouring?

Whenever I paste SQL code it automatically colours it. Like this:
Which is great. However, I don't like how it separates the lines of code into different rows. But when I try and paste the code into ...

**0**

votes

**0**answers

28 views

### Formula error in structured table

I have a structured table, a portion of which is shown below:
In the "Availability" column field, I entered this formula:
=IF([@Available]="Yes","Now","Not Now")
However, it creates an error that I ...

**0**

votes

**1**answer

57 views

### Pivot Table : How to group by date if the column headers are month names?

I have a table of expenses for multiple businesses and for each business, the expense is distributed into various accounts. The expenses are reported on a monthly basis; thus the table is provided ...

**0**

votes

**2**answers

34 views

### Microsoft Excel: display realtime filtering data from another worksheet

I want to display all rows that has Gender column equal to M inside sheet2. The data is retrieved from sheet1. The filtered data also has to be real time, meaning whenever I make change in gender ...

**0**

votes

**1**answer

22 views

### Compare two columns and paste it in third column code not working

I have two columns with below data:
DATA_TYPE DATA_TYPE Result
VARCHAR2 VARCHAR2 1
NUMBER NUMBER 1
VARCHAR2 NUMBER 1
I am using below code to do the comparison ...

**0**

votes

**1**answer

36 views

### data export from site is in lines, how to put it in table form

I exported some data from a nutritions tracking website to use in excel and eventually in SPSS for analysis. However the data is exported in lines/rows. I need it to be in table form so I can use it ...

**0**

votes

**0**answers

41 views

### Display a countdown timer for web query refresh

I have a web query set up to refresh data when the workbook is opened and then refresh data every 15 minutes, but I would like to display the last refresh time and the remaining time left until the ...

**-2**

votes

**2**answers

122 views

### Converting time string text to hours and minutes in Excel

I have a time string in a text-formatted cell that looks like this: "102:16:47.04". How can I convert it to time string like this: "102:16" ?

**-1**

votes

**1**answer

46 views

### Excel formatting a list

I have a list of one column as follows:
x1
y1
[blank]
x2
y2
[blank]
x..
y..
[blank]
I need to get this formatted into:
x.. | y..
[blank]
What's the easiest way to accomplish this in excel or bash?...

**1**

vote

**2**answers

38 views

### Formula to have a result in a column if the entered value is in between the two column list

I am trying to put a formula to figure out a particular cell in a column if the desired value is between two columns. Like if i put a value of 120, the result should show "8", as it is in range of 111 ...

**0**

votes

**1**answer

75 views

### How to hide zero values in Excel grouped bar chart?

Assume the following data:
X | A | B | C | D | E | F
Group 1 | 1 | 0 | 0 | 2 | 0 | 0
Group 2 | 0 | 0 | 3 | 0 | 1 | 0
Group 3 | 0 | 1 | 0 | 0 | 0 | 2
Basically I measured 6 elements A to F, so ...

**0**

votes

**1**answer

45 views

### Excel: Trouble graphing 3 sets of data properly

I've got this table:
Name Tech NotTech TechToNotTechRatio
Abc 115 121 0.95
Bca 127 186 0.68
Cab 135 160 0.84
Cba 149 196 0.76
Bac 142 185 ...

**0**

votes

**1**answer

50 views

### Excel combining IF formulas

I have 14 different IF formulas I am trying to combine. They are all different calculations (see below). For now I have each formula in a different column and then a new column which adds the values ...

**0**

votes

**2**answers

133 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

15 views

### Data validation drop-down list dependent on value in another cell, otherwise lock the cell

I've been seeing a lot of posts regarding dependent lists using data validation, but in this situation, I am creating a dynamic timesheet. There are two columns with different kinds of work and sub-...

**0**

votes

**1**answer

21 views

### Import XML to Excel, to date conversation issue

I need to import XML files to Excel book, but got one issue: Excel convert some number values to date.
It happens when numbers are separated with dot or hyphen. The "dot problem" is solved (i changed ...

**0**

votes

**1**answer

22 views

### Subtracting values based on another Column FID

As per attached JPG, i want to subtract values upper to lower row as per shown.
But when "ORIG_FID" change, then its start from first value and ends up where FID values are same. Please help me.

**0**

votes

**0**answers

14 views

### Networkx Pyhton add node list with their attributes?

I have a excel files for my nodes with their attributes. I need each node based on type has different color (last attribute) and different size. How can I add this node list excel file into Networkx ...

**1**

vote

**2**answers

114 views

### Excel Formula CONTAINS

I need a formula that will look for a specific text in a cell that is also referenced on another sheet and input the value next to it. Kind of like a vlookup but with an if statement. "if text ...

**1**

vote

**0**answers

18 views

### Excel spreadsheet/workbook data connections: Two way communication with applied filter?

So let me pose you guys a scenario.
There are several users all inputting data into a single spreadsheet. This work is initially assigned to these users by a manager who, after the data is input, ...

**0**

votes

**1**answer

17 views

### Advanced Filtering in Excel 2016

In Column A, I have 7000 rows of unique bore numbers. In Column D, I have 800 rows of bore numbers.(Column B & C contain data relating to Column A).
I want to filter the bore numbers in Column A ...

**0**

votes

**1**answer

40 views

### Why is Excel Document Printing at Bottom of Page when Orientation is Landscape?

We just replaced our office printer from a Canon ImageClass MF3240 to a much newer Canon ImageClass MF260. When we try to print Excel spreadsheets in landscape orientation the printer will print the ...

**0**

votes

**2**answers

70 views

### SUM column C unless value in col A matches col B

I'm trying get a SUM of values in column C only if value in cell A doesn't match any values in column B:
| A | B | C |
|--------|-------|-----|
1 | Tom | | 1 |
2 | ...

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

**-1**

votes

**1**answer

19 views

### Excel, If two columns match on different workbooks, then paste another string column from the 2nd workbook to the 1st workbook

How do I tell Excel that if a string column with company names matches another string column with company names from another workbook, then print the Contact Name from the 2nd workbook to the 1st ...

**0**

votes

**1**answer

19 views

### Cell value format in Excel

I'm trying to change how a cell appears in Excel, but I'm not sure how to do it. Let's say that we have a worksheet WSA with some data:
We also have some worksheet WSB in which I want to copy data ...

**0**

votes

**1**answer

35 views

### Word paste table from Excel hash marks instead of values

I created a table in Excel with 5 columns. The second column is formatted as date (dd.MM.yyyy). When I copy the table to Word all the dates in the second column are replaced with hash marks "######"?!?...

**-2**

votes

**2**answers

97 views

### Using INDEX/MATCH to return a value from a set of tables

I'm having a hard time writing an INDEX/MATCH formula. I need the formula to look through multiple rows to find the one that matches my lookup value. I have multiple headers for different months.
The ...

**0**

votes

**1**answer

40 views

### Deleting Duplicate Transactions - VBA or Function

Example Transaction Set:
Note the 3 transactions shown. The two transactions highlighted in green are the ones I'd like to delete or flag (doesn't matter).
Using VBA, the code is way too clunky. The ...

**0**

votes

**2**answers

21 views

### Excel: How do I compute a compound product & sum of two columns?

I have two columns of numbers.
I need to write a formula to multiply the two columns together, and then add all of the products together.
In this case: (16*1) + (6*0) + (4*0) + (4*0) + (4*0) + (2*0) =...

**0**

votes

**0**answers

18 views

### How to create a one dimensional distribution chart in excel

I have a set of data that I would like to benchmark against a distribution set that I do not have access to. I know what the 10th, 50th, and 90th percentile numbers are. In this case 10th-5,218; 50th-...

**1**

vote

**1**answer

42 views

### sum column = value IF another cell contains text but only if a different cell is NULL

I'm trying to calculate the sum of cells J10:M76 if B10:E76 = a text value, but if cells R10:R76 are not null (contain a value) I do NOT want to include the value that is in J10:M76.
I know this is a ...

**0**

votes

**1**answer

16 views

### Pivoting Data into a time series format

I'm having trouble getting my data into the format I want in a quicker way than copy and pasting. Right now my data looks something like this:
I would like to pivot it so that I have category in a ...

**1**

vote

**1**answer

59 views

### Chart on Excel with grouped data

In the image bellow, I have some data on columns Item, Type and Value. I would like to know how can I create a pie chart aggregated by the column Type. I mean, I would like just one slice for each ...

**1**

vote

**2**answers

61 views

### Using MIN with multiple MATCH criteria (Track and Field Stats)

As a track coach, I want to keep a running spread sheet of the athletes' best performances over various events in Excel. I'll then use conditional formatting to highlight athletes that qualify for ...