# Tagged Questions

**1**

vote

**1**answer

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

**1**answer

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

**1**answer

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

**18**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**4**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

31 views

### How can I get the secondary horizontal axis to the left and primary horizontal axis to the right in MS Excel 2013?

How can we get the secondary and primary horizontal axis to the left and right side respectively?

**0**

votes

**0**answers

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

**0**answers

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

**1**answer

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

**6**answers

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

**4**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**2**answers

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

**0**answers

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

**4**answers

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

**2**answers

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