Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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 ...