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)

-2
votes
1answer
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
2answers
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
1answer
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
2answers
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
2answers
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
1answer
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
2answers
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
4answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
3answers
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
2answers
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
2answers
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
1answer
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
1answer
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
3answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
3answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
3answers
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
0answers
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
2answers
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
1answer
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
2answers
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
1answer
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 ...