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)

1
vote
1answer
18 views

Move between sheets every 10 sec, and bring data every 20 min in one code

I need a script that switches between sheets every 10 seconds, and then runs some code every 20 min that brings some data using copy-paste function, and then loop until I press "Esc". This is my code ...
1
vote
1answer
832 views

Disable “Unable to open <URL>. Cannot locate the Internet server or proxy server” error

I've been having this problem in Excel 2003, but maybe it's also present in earlier versions. I have an Excel spreadsheet that imports data using a web query, which connects to a web page hosted in ...
0
votes
1answer
17 views

excel is refusing the hyperlink function

I want to insert an hyperlink in my excelt sheet. I tried the following example from office help page: =HYPERLINK("http://example.microsoft.com/report/budport.xlsx", "Click for report") Excel is ...
29
votes
18answers
135k views

How to make cells perfect squares in Excel?

In Microsoft Excel, I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done? Surprisingly, ...
1
vote
0answers
22 views

Display hyperlinked text

I'm trying to display the value of a hyperlinked text into another cell. For example, I have a column that contains several hyperlinks each linked to a specific cell in other sheets. What I would like ...
1
vote
0answers
29 views

How to use INDIRECT with a SUMIFS formula for a date range 1 [on hold]

Can the formula below be used with the "sumifs" function?=SUM(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()-1,COLUMN())))
0
votes
2answers
7k views

Excel: Move cell contents to comment

I'm using Excel 2007. I have a list of items and wish to take the information in the cells of one column and move it into comments for the cells in that column. Is there a way to do this that doesn'...
-6
votes
0answers
41 views

URGENT HELP -REQUEST - ONLINE /OFFLINE TEST CREATOR [closed]

I need to create an online if not at least an offline test with multiple types of questions which are already on my excel sheet. I am short of time and this has to be done to allow approx 70 to 80 ...
0
votes
2answers
3k views

Lookup Multiple Results for Multiple Criteria

I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...
1
vote
0answers
8 views

how to get csvkit to convert very wide xlsx files — weird error messages

I've been trying to convert a number of xlsx files which are very wide (over 200 columns) into csv files so I can aggregate them into a single file for analysis. I've been trying to use csvkit, but it ...
0
votes
0answers
20 views

having to keep track of previous day on a qry and data mart update that updates daily in excel

I am currently the "numbers guy" on my team. I have been able to add multiple query data onto one sheet keeping track of multiple parts of my teams stats. I was trying to do something that keeps ...
0
votes
1answer
19 views

using named ranges in a sumif formula

I have named ranges. They are columns on another tab within the workbook. I'm using a sumif formula to find value based on multiple criteria. The formula is =sumifs(H4,array1,b4,array2,c4). H4 is a ...
0
votes
1answer
348 views

How to add 2 hyperlinks in a single cell in Excel 2010?

I have an excel file that contains a list of steps that I follow at work. I want to add hyperlinks to the emails I have received & saved on the hard drive. Every time I try to add a hyperlink to ...
0
votes
0answers
14 views

excel 2013 Consolidating worksheets

I have multiple sheets I update monthly. I need to combine all these into one consolidated worksheet. However, I will add new information or make changes, so I need these to update automatically to ...
0
votes
2answers
41 views

I want to create a range in excel

I have the following cells: Number Band Color 1 10 A A1 2 20 A A1 3 30 A A1 4 40 B A1 5 50 B A2 6 60 C B1 7 ...
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 ...
1
vote
2answers
15k views

Changing a number in each time I print

I have an Excel sheet I use as an invoice. I want to print 100 pages and I want the invoice number to change from 1 to 100, so that each paper will have different invoice number. How can I do this?
0
votes
0answers
21 views

Apply formula to cells with data

Is it possible to apply a formula to cells with data without using macros? For example, user enters "A3 A6 A8" in a cell, and then it applies UDF "CONCATENATEREF()" to that cell that gets those ...
-1
votes
3answers
307 views

How do I use excel solver to solve this?

ABC Corporation is a Global Distributor of electrical parts and components. The company contracts to purchase components and parts from Europe, and it has them delivered to warehouses in three ...
-2
votes
0answers
22 views

Python excel handler

I have an existing python program to handle an excel file and its working fine. I need to modify this program to add some more features. when I am adding some code in it(leave about adding code just ...
0
votes
1answer
29 views

MS Excel, how to update the choice list of a group of comboboxes

I've created a MS Excel workbook, which consists of two worksheets. The second worksheet contains a list of items, the first contains a table, and one of the columns of the table is a bunch of ...
0
votes
1answer
26 views

How to convert 3 colum in an excel matrix?

I have many data set on 3 column as the tab above and I would like to convert to a like the one in the picture. Is there a function that do this in MS-excel 2007? I think I need to create a ...
0
votes
1answer
59 views

Microsoft Excel Data Table

So I have a lot going on with my current table, I use it for showing my portfolio in a snap: Except it's lacking a pretty looking pie chart. Here's the thing, I can do what others have suggested. ...
2
votes
4answers
2k views

Excel 2013 slow when Cell Editing

In Excel 2013 (on windows 7), when I select a cell & type something, most of the time it makes the computer very slow for few seconds, and takes time to display entered text in the cell. Tried ...
-2
votes
0answers
17 views

Using excel for pantry inventory [closed]

I am trying to create a simple log or database of my wife's VERY large pantry. The whole idea started with a handheld laser scanner I bought. thinking if I scanned the UPC I could link it to one of ...
1
vote
2answers
43 views

Add values in a column until a certain point in excel and repeat

I have several thousand values similar to those shown in the picture provided. I am attempting to sum the time values in column K, but only if they have a value of "flag" in column M, and only ...
1
vote
1answer
35 views

Splitting one Row with Multiple Columns into Multiple Rows

So I picked up this VBA code ... Sub NewLayout() For i = 2 To Cells.Find("*", [A1], , , xlByRows, xlPrevious).Row For j = 0 To 2 If Cells(i, 3 + j) <> vbNullString Then ...
13
votes
4answers
54k views

Is there an Excel formula to identify special characters in a cell?

We have about 3500 documents whose filenames need to be manually scrubbed to remove special characters like brackets, colons, semicolons, commas, etc. I have a text file that I've dumped into excel, ...
0
votes
1answer
50 views

Excel 2010 - how can I combine 2 rows of data into 1 row (multiple columns of data) across numerous rows

I have multiple rows of contract data that have the same 'Synonym ID' that require the information from 'Device1' and 'Service1' columns to be combined on the first row with that particular Synonym ID....
0
votes
2answers
31 views
0
votes
0answers
19 views

Using graph, spit out pre-consolidation pressure using Casagrande's Method

I need to create a excel macro that spits out the Pp based on the curve (click the link). This is a consolidation curve from consolidation test. Pretty common in geotechnical engineering practice. I ...
1
vote
0answers
19 views

Excel Pivot table layout for Registrant and payment data

I have data similar to this in an excel pivot table. The pivot table lays it out so that every registration number has 1 row and the person it is associated to it is in the column to the left. Email ...
1
vote
1answer
18k views

Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...
0
votes
6answers
3k views

Excel COUNTIF Slow

I'm having an odd issue in excel that I haven't run into before. I have an excel sheet that I'm attempting to pull some specific records from, requiring that I know of duplicates. I am using a COUNTIF ...
2
votes
4answers
74 views

Convert 02:45:00 to 2Hrs 45Min

I've a sheet in Excel, which have a calculated "Duration" field formatted to hh:mm:ss What I am wondering is, is it possible to convert/output that value as a Text string also in another column, eg: ...
3
votes
1answer
4k views

Is there any way to suppress the Excel 2007 warning “in a different format than specified by the file extension”?

We have an application that exports data using the older Office XP/2003 XML Spreadsheet format. These files are saved with a .xls extension so that they can be launched directly, without having to ...
0
votes
1answer
16 views

Remove notations not used

I use custom notations in excel for the data labels of my graphs. I've already used a lot of the notations, but now I want to delete these, how can I do this? For example in the picture below, I want ...
0
votes
3answers
55 views

need to print a sequence of numbers on excel 2013

I have an Excel sheet and I resized the print area to print on A5 size. Now I have 2 cells that fit in the "A5" paper and each one has a number. What I need is to print numbers from (1 to 5000) with ...
0
votes
0answers
16 views

Comber cell contains to rang (not match not vlookup not index)

Blue is range "Alist", cell yellow which contains names which one of them is to be compared ie, if the yellow cell contains a name from blue range = OK. How to return the value of the green cell to ...
1
vote
2answers
11k views

Excel crashes everytime when saving a specific file

The instant I try saving a particular excel document excel will crash. How do I solve this problem, I've tried saving as different excel formats but I got the same result, except for when I saved it ...
1
vote
2answers
56 views

How to write 2 calculations in one Cell in Excel

I have GPA and I want the cell just shows me if the student is passed or failed without showing the GPA as number. Can I?
2
votes
3answers
8k 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
2answers
8k views

Count from a certain cell until a blank cell

I'm trying to create a dynamic formula which counts all the rows from cell D3 downwards until a blank cell is reached. I want to be able to add new data everyday and have the range automatically ...
0
votes
1answer
3k views

Grand Average in place of Grand Total in Pivot Table

In a pivot table I want to change the Grand Total field to Grand Average. For example. Row Labels Day1 Day2 Day3 GrandTotal 1 10 20 30 60 2 15 25 ...
4
votes
2answers
5k views

Grouping a field in one pivot tables groups the same field in another table

I've got a data sheet, which basically contains an amount and a date. I've created several pivot tables, each on one sheet. I have given names to those tables, such as "tab_days", "tab_weeks", "...
4
votes
4answers
4k views

How do I get excel to close completely after creating a macro in a personal workbook?

I am using Microsoft Excel 2007 and have several macros in my personal.xlsb workbook, which I use often, so it is very convenient that Excel opens them automatically when it starts. What I don't like ...
0
votes
2answers
35 views

Protect content of certain cells without protecting worksheet

We have a excel 2016 workbook with multiple tabs, each tab is dedicated to a specific sales person. Each salespeep, logins from a form, and his (only his) worksheet is unlocked and allow for editing. ...
-5
votes
0answers
38 views

Match function in Excel doesn't seem to perform as expected [on hold]

I have a problem with the Match function. For some reason, when I am looking for an exact match to (example: a1 + b1) using an array of numbers (c1:c10), it will not find the match. Even though I'm ...
3
votes
4answers
60k views

How do I move the selection down one row in Excel 2007?

Is there a way to move a selected range to the next row? Let's say I have "E9:H9" selected and want the selection to move to "E10:H10". Is there a shortcut for it? The selection should not be ...
1
vote
2answers
50 views

How to select the first number in cell in Excel?

I have a table that stores both a number and some text in a cell, and I want to do an arithmetic operation based on the numbers. So my table looks like this: Number1 | Number2 | Product 2 ...