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
0answers
16 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
4 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 ...
0
votes
0answers
7 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
3 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
11 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
0answers
14 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
1answer
6 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
10 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
2answers
19 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
7 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
9 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
9 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
40 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
21 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
22 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
9 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
44 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
20 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
20 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
13 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
13 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
25 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
0answers
12 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
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 ...
2
votes
2answers
22 views

How to name all data except for header row in Excel

Suppose I have some data like this: Name Number alan 1 bobby 2 cory 3 david 4 Assume that "Name" is in cell A1. I'd like to be able to name this range but not include the header row. I ...
0
votes
0answers
11 views

How to force Excel to use English formats on non-English locale?

I'm using English Windows, English Office but my system locale is Czech. This unfortunately leaks into Excel: How do I get rid of this? I want my worksheet to be pure English (US) – all amounts in ...
3
votes
2answers
22 views

Padding zeroes in non-Text lists

I have a list of numbers that have 3 digits after the dash (FL-100), but in the list are numbers that are formatted with only 2 digits after the dash (AR-12). They all need leading zeroes in order to ...
0
votes
1answer
10 views

Reset code and userform window positions in Microsoft Office VBA

When we open UserForms and code modules in a Microsoft Office VBA project (Word, Excel or Access), we can change the size and location of these windows. MS Office saves the last position for these ...
1
vote
0answers
26 views

Conditional formatting with several conditions depending on different cells

I currently have a table in excel that looks like . The table shows four projects, each with three stages with each having an expected and actual start date for that stage. I want to create a ...
0
votes
0answers
25 views

Excel big database

I have a really large database and I have to see which number appear most of the time. I know for mode function, but it will give me only the most appeared number, i would like to have first 5 or 10....
0
votes
1answer
19 views

Excel - How to combine a hyperlink cell and text cell?

My requirement is I have one cell with text and the next cell with a hyperlink. I need to add only the hyperlink to the text. Any ideas on how this can be achieved? I want to automate or use a formula ...
4
votes
5answers
70k views

Excel: convert a column with hyperlinks to just display the links

In Excel, I have a column of links that display text instead of the actual link. I actually need the links, is there a way to bulk convert the entire column so that the links are exposed? Otherwise I ...
0
votes
2answers
13 views

Office 365 Excel > Sort > “My data has headers” grayed out

Using Excel from Office 365. I've selected a range of cells from Row 1 down to Row 200. The cells have a header row, but when I try to sort the data My data has headers is grayed out and can not be ...
0
votes
1answer
5k views

How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...
3
votes
1answer
6k views

Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells

I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct. The only way to overcome ...
0
votes
1answer
16 views

Clearing a value when an option is selected from a drop down menu in Excel (VBA)

Good Morning, I'm trying to write a code in VBA, that while selecting from a drop down menu from D2, it will clear any value from E2 and F2 without removing the formatting. I have tried the follow ...
-1
votes
0answers
9 views

Parse Excel to xml using vba using Excel column data as XML attributes

I have an Excel table with data in column1 and id's to this data in column2. column1;column2 dataCol1Row1;dataCol2Row1 dataCol1Row2;dataCol2Row2 Using any of the VB examples given in Parse Excel ...