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.

learn more… | top users | synonyms (2)

0
votes
1answer
12 views

Pasting exact values in Excel

I apologize if the question title isn't very informative. I've got a long list of numerical codes that I'm trying to paste into a column in Excel. The problem is that the vast majority of these codes ...
0
votes
1answer
7 views

how can I get Excel to show the values in a complex formula?

I can get the values to show in a simple formula like A19+A20, but what a about a more complex formula? The formula I'm working with is this: =(A19+A20)/(1-A15). I have one cell where the answer to ...
0
votes
0answers
5 views

Disable auto date formatting in Excel

My cells are set to text format but when I find and replace numbers in them they automatically change themselves to date format even though I don't want that. How do I globally disable automatic ...
0
votes
1answer
9 views

VBA Function to parse email body for email address, write to excel

I have a requirement such that I need a function to iterate through all emails in an Outlook (2010) folder and grab an email address from the body of the email. The emails are found from Inbox \ ...
0
votes
0answers
6 views

Trying to create a line with a Primary Y and a Secondary X in a graph that has two Y and two X values

I created a chart with two X values (2015 for one and 2016 for the other) and two Y values (Hours for one and Gallons Per Min for another) by adding a secondary x and y axis. It allows me to graph ...
0
votes
0answers
13 views

Excel return how many times a value appears

I have an excel file that I keep track of what cards I have for a game. What I want to do is to have a field that whenever I click on it, will prompt me to click on a cell and get the text of the cell ...
0
votes
0answers
8 views

Copy-Merge w/ Exclusion in Command Line

I have a network drive that has hundreds of folders in it, each with a few files. The one of interest is an Excel file named XX_Form_54. I would like to create a folder on the desktop and add all ...
3
votes
2answers
21 views

MS Excel Conditional Format

I seek to create a conditional format on a spreadsheet which logs invoices on the date they were received. Below is the sample I want to create a conditional format where the 'date invoice received'...
0
votes
0answers
16 views

Excel : Check in which range is a specific value?

I make two sheets : one called 'Result' which tracks values between 0 and 100 and another one called 'range' which display a value if a result!value is in a specific range (0-14, 15-19, 20-24, ..., 76-...
-2
votes
0answers
12 views

How to clear data from webpages to

I know how to take data from webpages to Excel cells. Now I found some pages of which I need very few values, but the pages are very rich in information for me useless. The question is Is there ...
0
votes
1answer
42 views

How can I link excel cell to updated value from web?

Is there a MS-excel function that allow to link data from the web? I am tryning to create a model based on MS-excel spreadsheet with financial data. How can I update the cells with the today value ...
1
vote
3answers
237 views

Excel grey and black boxes on secondary display

My secondary screen doesn't display Excel properly: it has grey, black and white boxes and lines everywhere. As I scroll up and down, or zoom in and out, the boxes disapear and and then reappear in ...
0
votes
2answers
4k views

Defining Variables in Excel

I have two lists of data, x and y, one in a row one in a column. I would like to populate a chart of rows and columns with a complex formula that is the same for each chart point, the only difference ...
0
votes
1answer
18 views

Excel Macro: update sheet or create a new one based on a single criteria

I want to write a macro which updates a single sheet out of many in an Excel workbook, based on a single criteria. The first sheet of my workbook is titled "Input"; I copy and paste a client's ...
0
votes
1answer
26 views

Is there a way to make a single bar chart that tracks color based on date in Google Sheets or Excel?

I've attached an image that's the best way to describe it. As the date increases from left to right, a different color for that range is displayed. Some sample data: Date Temperature Week 1 ...
0
votes
0answers
26 views

Evaluate Formula Gives Wrong Result

Why would the evaluate formula give the wrong result with the correct values? In the evaluate formula window of Excel I get the final following steps. 370+27.5*(9.5) 370+27.5*9.5 370+261.25 4,725 ...
0
votes
0answers
11 views

Runtime Error 1004 Application-defined or Object-defined error in excel

I'm pretty new to the Macros and coding but have been following along with some videos to get what I can out of them. I completed 1/8 of the what I wanted to do and when I went to run the macro again ...
1
vote
0answers
19 views

Block Network access for Microsoft Excel

I have a macro that is stuck on running and has frozen my Excel. Basically its a loop through roughly 80000 rows performing SQL queries on each row with ADO.DB Save disabling the network card, is ...
0
votes
0answers
10 views

How to increase all values at once in Excel (about 15K)

Lets just say that the values currently are 1 1 1 1 1 3 5 4 I want to add 1 to all the numbers so that the result is 2 2 2 2 2 4 6 5
-1
votes
1answer
20 views

How to accumulate several data entry worksheets onto one 'Master' worksheet in Excel?

How do I accumulate stock records including hyperlinks entered on separate worksheets related to different areas in a work place onto one master worksheet where the total stock can be viewed, searched ...
0
votes
1answer
14 views

Excel doesn't show all data points

I have an Line graph in Excel 2010 displaying data on 7 areas every friday through the end of the year. The graph currently shows the data through the end of October but will not display data beyond ...
0
votes
0answers
20 views

Excel 2013 single column values multiple worksheet changes

I have been tasked at work with creating a calendar template that can be used by multiple groups with a standard set of variables & color coding. Okay, not a big deal since Excel has some ...
0
votes
1answer
29 views

Using indirect function within an Index formula, when the data is on a separate worksheet

This formula uses tabulated data on tab antistatic. =INDEX(apestatic!$E$42:$L$2140,MATCH('Graphed data'!$E4,apestatic!$E$42:$E$2140,0),MATCH(H$3,apestatic!$E$42:$L$42,0)) Along the left of the ...
0
votes
1answer
13 views

Searching in a cell Right to Left but stopping at the first instance

I have column A with "Customer Name-Account Number (Serial-number)". So, an example could look like: ABC-12345 (1s39-a29a-23sh-akjf). What I'm trying to get is just the customer name "ABC". ...
0
votes
0answers
12 views

excel chart mutiple data sets doesn't align properly

I'm trying to put 3 different data sets onto same chart, 2 of which use the same x-axis values (easy), and third that uses different (there is the problem). Best explained with a picture: My data: ...
0
votes
0answers
11 views

AutoFit Cell content when printing

enter image description here I created an excel application where the users enter the comments for every question. I have designed the excel spreadsheet in such a way that, I have merged cells to ...
1
vote
1answer
5k views

Automatic Excel list exported from SharePoint not keeping my local data?

hope you can help!? I have set up a table in Excel which does a great job of exporting data from a SharePoint however I have added my own columns to add (local) information to each entry. ie. I am ...
-3
votes
3answers
45 views

Locating Hyperlinks in documents without opening them

Is there any chance of locating hyperlinks in a documents without opening them? My friends and I have been working on a project with roughly 300 to 400 documents including MS Word, Excel and ...
0
votes
1answer
22 views

Excel SUMIFS Formula Sequential Date Criteria?

=SUMIFS($I$2:$I$2221,$M$2:$M$2221,"VISA",$B$2:$B$2221,"June 1") This is the formula I am using for a sales analysis worksheet, that takes the clutter from the POS report and breaks it down in a ...
0
votes
1answer
3k views

Treating multiple fields as a single pivot table row label and a value source for subtotals in Excel

I have a tabular extract from a DB that has the following fields from orders and order line items: order customer (PK1) order serial no (PK1) order detail 1 order detail 2 ... order line nr (PK2) ...
0
votes
0answers
23 views

My 'show items with no data' option is greyed out in Field settings

I want to set my pivot table to show no data items, I normally click on 'show items with no data' in field settings however this option is greyed out for me. I have also tried using 'show items with ...
0
votes
0answers
10 views

VBA Excel (2003) Macro to sequentially Open Workbooks, run Auto_Open in each, and Close

Code for stepping and looping through related workbooks (all macros in opened workbooks identical). This code is in a separate file/workbook from those opened in the this code. Public Sub ...
1
vote
2answers
6k views

Can I link images using a relative path?

I am working on an MS Excel workbook that contains around 200 images. They are currently saved within the workbook, so the file becomes huge and working gets very slow. Linking the pictures without ...
0
votes
3answers
47 views

Excel: sum values corresponding to multiple matching or individual numbers

hoping someone can help with this one: The numbers on the left (phone numbers) will be either individual or repeated. Each row has a number in the second column that is associated with that phone ...
2
votes
3answers
9k views

Sync Google Form Spreadsheet with MS Excel

Is there some way to pull the responses from a Google form that is on a Google Spreadsheets into MS Excel?
0
votes
1answer
14 views

Advice making a multi line chart with daily count data

This is what my raw data looks like..... raw data image I would like to use this data to create a chart that display's Install date in the X axis, a daily sum of records for each installed by name in ...
-1
votes
0answers
21 views

Copy and run procedures on sheet tab names

I have a spreadsheet with a list of sheets each sheet has a Region name. Step 1 Open file called "NameofFile" When the below code moves this to a new book I want to give the name or save file as "...
2
votes
2answers
11k views

Hyperlinks to web pages in my Excel workbook don't work now

Hyperlinks to web pages, saved in my Excel workbook don't work after upgrade to Windows 7 & new hard drive. Have had this spreadsheet for years. I was always able to click on the link and it ...
0
votes
1answer
21 views

Formula won't copying with reference because it links to another file

I am using Excel 2013 and have run into an issue. I have large amounts of information to go through with only a single repetitive way to do it. I am using the formula =rept() which links to another ...
0
votes
1answer
15 views

Need help tagging in excel

I am trying to sort this data in the best way I can, column B cells exist in multiple categories under column A. Therefore I would like to tag all the column B cells with their corresponding column A ...
0
votes
0answers
14 views

Excel: Add new rows to a table with a subtotal row, when data added to a specific column on the last row

How do I get an Excel table (with a subtotal row) to automatically add a new row when I enter data in column C of the last row? At the bottom-right of the table I have 3 cells with basic SUM formulae,...
2
votes
2answers
27 views

Combine multiple email addresses (in separate cells) into one cell (separated by comma) Google Sheets or Excel

I'm trying to combine multiple cells with email addresses into one cell where emails are separated by commas. I've used this formula: =P2 & ", " & Q2 & ", " & R2 & ", " & AD2 ...
0
votes
0answers
29 views

How to check the values are increasing or decreasing between different columns?

In the table below each row has a different behavior. Note that, In the first row, the columns "pool1" the values are decreasing. Also decreasing for columns "pool2" and "pool3". In the second row ...
0
votes
1answer
35 views

How to replace an array excel formula with another regular one to avoid long calculation time

EXAMPLE by using an array formulas in range (E11:E16) According to the above example: To count unique customers in range (E2:E7) that meet only the following criteria: 1- Purchased Product 1, ...
3
votes
6answers
26k views

Apply conditional formatting to multiple rows

When using the Conditional Formatting in Excel 2013, I can't seem to apply one rule to multiple rows. I use data which is not related in multiple rows. For example, row A contains prices, row B ...
0
votes
1answer
21 views

How to find time difference between two cell in excel sheet?

"14/07/2016 09:26:59" & "14/07/2016 09:28:47" I could not find difference between this time. I have enter formula =A2-A1 result shows "#VALUE!" Please help me.
2
votes
1answer
3k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
0
votes
0answers
16 views

Combine data of unknown row size from multiple Excel tabs into one tab

I have a lot of tabs with similar data. As an example, let's say that I have three tabs: men, women, children. All tabs contain data of the following type. Name Surname Age Address How can I merge ...
0
votes
0answers
25 views

EXCEL. An array that displays the most recent set of data(based on date) of a customer

I'm looking to pull data from one sheet into another sheet where I pick the most recent date of information on a person. So I may have 50 entries for Bob, but on sheet 2 I just want to post the most ...
0
votes
2answers
23 views

Need to change rows to columns

I have a spreadsheet where 5 locker combos for each locker were entered but we did them in a list going down the rows. Now they want the five to go across in columns. Is there a way to change these ...