**-2**

votes

**1**answer

30 views

### In Excel 2007, what does the Header Row check box do to the worksheet

When do I use the header row check box in Excel when working with tables?

**0**

votes

**2**answers

75 views

### Round any decimal number up to the next tenth number

In Microsoft Excel 2007, which formula is used to convert the following decimal values in this particular manner?
1.3 should convert to 10
2.5 should convert to 10
4.8 should convert ...

**2**

votes

**1**answer

223 views

### CSV filename bug concerning dots in Microsoft Query (via Office Excel 2013)?

After hours of struggling it looks like I've found a bug regarding csv file processing by Microsoft Query via Office Excel 2013.
I'm trying to generate a Chart from csv data. Every hour a new record ...

**0**

votes

**2**answers

6k views

### Find and name a text box in a spreadsheet using VBA

Each sheet in my Excel Workbook has one basic text box. Unfortunately these are named differently each time (Text Box 1, Text Box 17, etc.).
I have a code that finds text box 1 and moves it. However, ...

**0**

votes

**2**answers

792 views

### I want to compare two coloumns in excel and print the values of the matched rows in other coloumn in Excel?

I want to compare two coloumns in excel and print the values of the matched rows in other coloumn in excel...
We have three coloumns A1,B1,C1.. we want to compare A1 and B1 if rows matches we want to ...

**1**

vote

**1**answer

596 views

### Shortcut/hotkey to open/jump/navigate to function definition in VBA editor

When I am in Formula bar and my cursor is inside the name of a function, is there any way I could use a hotkey/shortcut to jump to the function definition in VBA editor so that I could check out the ...

**0**

votes

**2**answers

11k views

### How to Open specific file in specific folder with macro excel

How to Open specific file in specific folder with macro excel.
Example I put Path in cell A1 "D:\My Data", and I put sub directory in A2 "Kitchen"
and last I put file name in A3 "Rack.xls"
Thanks ...

**3**

votes

**4**answers

6k views

### Mass Convert .xls and .xlsx to .txt (Tab Delimited) on a Mac

I have about 150 .xls and .xlsx files that I need converting into tab-delimited. I tried using automator, but I was only able to do it one-by-one. It's definitely faster than opening up each one ...

**0**

votes

**1**answer

107 views

### Consolidate multiple data rows with three common elements and add specific values from each row

I need to consolidate 400.000 rows of order level data, by order number, while adding the ship quantity for each row with the same order number.
I need to consolidate multiple data rows with three ...

**0**

votes

**1**answer

4k views

### ActiveSheet.ChartObjects(“chart”) always returns Nothing?

I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that?
Sub DeleteGraph()
Dim graph As ...

**2**

votes

**1**answer

172 views

### Excel conditional formatting always relative?

I'm creating a little project management spreadsheet for myself in Excel 2013. It looks like:
Notice that the columns on the left use the Data Bar Conditional Formatting, but don't look quite ...

**0**

votes

**1**answer

1k views

### Sequential Number in Excel within Specified Range

I have been looking for the macro since last week but with no luck till yet.
Would appreicate the efforts if you please get me out of the problem that i am facing,
I have created excel template (used ...

**0**

votes

**1**answer

961 views

### Split last two words in a sentence into two different cells in MS Excel

Temasek Boulevard, Suntec Tower, (Singapore 0389)
The above sentence is a address . The last two words is country name (singapore) and zipcode (0389).
How to split country name and zip code in two ...

**0**

votes

**1**answer

726 views

### Email to multiple users from Excel table

I have to send multple emails to some users from an excel table. My table contains several users and for each of them I have some row with some actions.
action user
...

**1**

vote

**0**answers

611 views

### Excel - One Slicer To Rule Them All

In excel I have multiple sheets with different pivot tables and charts. Each of the sheets has different slicers, but they all share one in common. I would like to make a global slicer on my main ...

**0**

votes

**1**answer

17k views

### How to show an additional single point on a line graph in Excel?

I have a data set which shows the "efficient frontier" curve and a data point showing the decision made. I wish to have the data point be plotted in relation to the frontier but as an isolated point ...

**0**

votes

**2**answers

90 views

### Divide information

I have an Excel file with several rows (about 1k).
Each row describe some action of one user and (my bad) for differents actions there are differents rows. Something like this
action ...

**0**

votes

**3**answers

2k views

### Split column into multiple columns--datewise

I have a column in Excel with 3,652 values. How do I split this column date-wise so that I have ten columns, one for each year, starting at a specified date?
From comments:
I am working with daily ...

**0**

votes

**2**answers

475 views

### How can I get the Max function to return a value in the winning cells column but not the winning cell itself?

1. Weeks 22 23 24
2. 3 7 1
3. 4% 9% 1%
4. 4% 2% 2%
For example in row 3, how would I get the MAX function to have 9% win but then return the number 23 a row ...

**1**

vote

**2**answers

5k views

### Get Excel to base tick marks on 0 instead of axis ends (with fixed maximum or minimum)

In other words, I want Excel to anchor the tick marks at 0.
I am trying to get an axis that goes from -35 to 35, but with the ticks on multiples of 10:
30, 20, 10, 0, -10, -20, -30
I have set set ...

**0**

votes

**1**answer

346 views

### exec 2010 VBA related error: “can't find project…”

Have made a (refinery process industry-)model under Excel 2010 with many macro's (based on a Excel 2003 sheet)
Had some difficulties getting it to run wih the right addins but OK now.
However, other ...

**0**

votes

**1**answer

125 views

### Excel_prefixed with 0 and how to concatenate those columns in excel

https://www.icts.uiowa.edu/confluence/display/REDCapDocs/Preserving+Prefixed+Zeros+in+Excel
with the help of the above link i prefixed the 0 in excel.
Now i want to concatenate these columns A &B ...

**0**

votes

**3**answers

1k views

### Method to convert Zipcodes to Addresses

At my mother's workplace, she often accesses the database and pulls out numbers in order to form reports. From selecting data Oracle to outputting reports in Excel format, she has come across this ...

**0**

votes

**1**answer

2k views

### Match multiple time-series columns?

I’m a new noob to the forum, would appreciate if anybody could provide some help.
I’m using Excel 2013. I have 5 sets of columns; each includes a Time column and a Price column. However, the 5 ...

**14**

votes

**3**answers

10k views

### Sorting Excel column by IP address

I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...

**0**

votes

**1**answer

2k views

### How to make Excel cells' values cannot be changed its value via keyboard inputs

Let's take this simple Excel file as a sample for my question. Please note that it contains permutation macro VBA script.
I want cells in column B to be read-only/unchangable to keyboard inputs i.e. ...

**5**

votes

**1**answer

26k views

### Find and replace multiple values within selected cells

I want to run a find and replace on multiple values within a range in excel with values from 2 columns: A with the original word; B with the translation. I already found the VBA code to get this ...

**2**

votes

**1**answer

292 views

### Sorting Common Values by Row in Excel

I have two sets of data from two years as below which needed to be sorted by product and row. Eg. I need A2 and its product sales on the same row for both years.I have had a look at the the solution ...

**0**

votes

**1**answer

9k views

### Expanding only selected rows in Excel using VBA Macros

I have written the following VBA code that contains a condition where if the Cell#="Yes" then expand the bottom row, else if Cell#="No" then collapse the bottom row.
Private Sub ...

**0**

votes

**1**answer

753 views

### How do I stop a table sort in one sheet from changing the variable of a cell in another sheet that references the cell in that sorted table?

My problem is this:
In Sheet2, I want to reference an item (let's call it Widget 1) in Sheet1. So, in a cell in Sheet2, I have:
=Sheet1!B65
This means that the cell in Sheet2 will always equal the ...

**0**

votes

**1**answer

772 views

### Extension for “Dynamic Excel Files”

I downloaded a file with a .xls extension. I thought it was a regular excel spreadsheet file so I opened it using Excel 2007.
However, it tells me that the file I'm trying to open is in a different ...

**0**

votes

**2**answers

78 views

### MS Excel: is 'ABCD always exactly the same as =“ABCD” in a cell?

As described in the title, is 'ABCD always exactly the same as ="ABCD" in a cell? It says that all the characters after the beginning apostrophe will be treated as string, so does that essentially ...

**0**

votes

**1**answer

33 views

### Excel Find lowest cell and return title

I have a spreadsheet I need help with please.
I8, M8, Q8 contain the numbers. If I8 is the lowest, return "WILL", if M8 is the lowest, return "AC", if Q8 is the lowest, return US.
Thanks,
Mitch

**0**

votes

**1**answer

3k views

### Solving a linear equation with excel

Sorry if this is the wrong place to ask (Meta says it's the right place but you never know) but I'm really struggling with finding a simple answer to this.
I'm using Excel 2011 for Mac, and want it ...

**0**

votes

**1**answer

1k views

### How to calculate a weighted average?

In a pivot table:
hits viewTime
2 100
3 300
4 540
5 10
I would like to calculate the weighted average of the viewTime. I can "just" through out a formula, but I'd like it to work even ...

**1**

vote

**1**answer

13k views

### Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2).
My problem is the percent changes from -4 to +4.
A change ...

**0**

votes

**1**answer

162 views

### how do i get a simple IF function to work in Excel only when another cell has a value in it?

How do I get a simple IF function to work in Excel only when another cell has a value in it?
I've tried =IF(ISBLANK(G4)="Sold","Closed","Open") but that didn't work so I was wondering if anyone could ...

**-1**

votes

**3**answers

19k views

### Microsoft Excel. Inserting a common thing to entire row/column

I'm encountering a basic problem with excel and outlook. Please give it a thought.
I have a list of phone numbers on excel sheet as well as outlook. It's just one column.
All I need to do is insert ...

**1**

vote

**3**answers

14k views

### Plot cumulative data in Excel

Is it possible to plot data in excel without having to define the function of the data in an extra column?
Think of this simplified example:
There are two columns with numbers A and B. Is it ...

**2**

votes

**1**answer

339 views

### how to determine which values in a given set of cells will add up to a numerical range

In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers:
1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16
26 ...

**0**

votes

**1**answer

721 views

### How do I get Copy & Paste to work like Cut & Paste with formulas in Excel 2007?

Excel 2007 when I Cut & Paste =K62 to a new worksheet and I get =Scenario!K62. When I copy and Paste it I get =REF!.
How can I get Copy & Paste to work the same way as Cut & Paste does?

**1**

vote

**2**answers

870 views

### Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)

It could be an easy question but I can't find a proper way to accomplish my task.
I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph ...

**0**

votes

**1**answer

62 views

### expanding Excel MATCH function on column

I have 2 columns in a sheet where the 2nd column is contained in the first. I mark each of them using MATCH and it works for a defined range , but when I try to expand the function to the whole column ...

**1**

vote

**1**answer

1k views

### Conditional formatting for entire row based on fixed column

How do I create the following conditonal formatting:
If the date in G3 is older than today, turn all of row 3 red
So in other words I want my entire row to be formatted based on the value in the ...

**1**

vote

**3**answers

366 views

### Utility that can print documents and merge the output with several other PDF files

I have a big book that consist of several static documents and a few dynamic ones (primarily Excel with links). The process of printing all this to one PDF as required by my customer takes way to much ...

**0**

votes

**0**answers

33 views

### How can I create a “spectrum” graph in Excel? [duplicate]

I'm performing some data analysis. I would like to create a "spectrum" graph like the link below to indicate the distribution of some special data occurred over a series of events. (I don't know what ...

**0**

votes

**2**answers

59 views

### MS Excel: query for rows where cell A & B are identical but C is different?

I'm trying to clean up some really bad data that I inherited and I'm looking for a way to 'ask' Excel to somehow bring to my attention all rows where cell A & B match but cell C is different.
...

**4**

votes

**1**answer

478 views

### Line Graph using Row summations

I'm having some trouble in Excel producing a line graph for the following data:
+------+--------+-----------+-----------+
| Id | Type | Owner | Date |
...

**2**

votes

**2**answers

219 views

### How to create number +1 from the previous sheet

I want to copy single sheet to multiple sheets in the same workbook with macros,I know how to do it but I still have further question.
I am using formula:
Sub Button3_Click()
Dim x As Integer
Dim y ...

**0**

votes

**1**answer

2k views

### I need to have a formula that will choose the Least value out of 3 cells

I need to have a formula that will choose the least value out of 3 cells.
Cells are as follows with random numbers
I29=5
I30=10
I31=15
Currently I’m using
...