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
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
25k 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
281 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
736 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
749 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
31 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
160 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
17k 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
335 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
694 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
862 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
365 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
58 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
459 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
213 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 ...
2
votes
2answers
81 views

How to split contents of a single column into 2 columns

I'm using Excel 2003. I have a spreadsheet that currently has 500 rows of data and just one column (A). For example, the first five rows look like this: A 1 loremipsum=fufu.com 2 ...
0
votes
1answer
227 views

Excel macros how to autofill cells?

When I run a macro, the value in cell AB2 changes. I want another macro named copyStuff to run automatically when the value in cell AB2 changes to 6. Please help.
1
vote
0answers
781 views

Why recovered .xls and .doc files show as symbols?

I formatted an NTFS drive (and re-installed windows) which had some important .doc and .xls files, I used 2 recovery software and both recovered my files but seem to be corrupt, when opened they ...
2
votes
1answer
679 views

Get location of variable in Microsoft Excel formula

As an Excel beginner, I opened a sheet which contain a cell where we can see =myVariable as the formula. What is myVariable, and how can I locate it?
0
votes
0answers
579 views

Excel: Bulk insert to multiple cells

My data analysis script returns something like this as an output: [1.041, 2.497, 3.123, 1.123]. I want to present this data in an Excel spreadsheet, so I want to have a row with a first cell as 1.041, ...
0
votes
2answers
191 views

Excel specific cell conditional formatting

I am trying to format a whole column (A1:A100) based on the values on each row. For example: If A1 > 0, then cell should be red If A2 < 0, then cell cell should be green And so on ...
4
votes
3answers
4k views

Convert Large HTML Table to CSV

I've got some data (basic personal details) which I need to export from an old legacy system to a newer system (MySQL DB). It's approximately 200MB split across 6 files. The system I'm exporting from ...
1
vote
2answers
711 views

Find broken links to other documents in MS-Office documents (Word)

In our team we have a shared folder with all the documents. Most documents contain hyperlinks to other documents. From time to time, we move some files and links get broken. I need a tool that ...
0
votes
2answers
2k views

Find Last Date Value in Excel 2013?

I have from B1 and onward(C1,D1,etc), I want to find the last date that is filled in. How can I do this in excel?
0
votes
2answers
279 views

Excel Modulus Operator MOD(0.9,0.3)

MOD function in Excel should return the Modulo Remainder in Excel I believe the Function =MOD(0.9,0.3) should give 0 since basically 0.3*3 is 0.9 But it gives 5.55112E-17 . Any hints to whats ...
1
vote
1answer
44 views

Excel date issue

I have the formula =RANDBETWEEN(DATE(1930,1,3),NOW()-1) in a cell to give me a random date. I have the format of the cell set to a date so the random number looks like a date. For example 38562 looks ...
0
votes
2answers
627 views

Increment a cell value every 23rd line

I have the statement below at every 23rd line in an excel sheet CSV format (there are no formulae in the document, I just assumed using excel would be the easiest way to change this!) ...
0
votes
0answers
90 views

Find match in Excel 2010 from 2 sheets & copy corresponding contents from sheet 2 to sheet 1

I have 2 worksheets: Worksheet 1 with Column H need to find a match on Worksheet 2 with Column F If a match is found, I need to copy the contents of worksheet 2 column g to worksheet 1 column E. ...
0
votes
2answers
58 views

Two excel tables - remove from table A any records also on table B

I have two tables with 3 columns each (name, phone number, email address). The columns in each table hold the same kind of values. One table contains all contacts, while the other contains contacts ...
2
votes
3answers
4k views

How to protect data validation to fail while copy and paste data?

I am using data validation on a column by a predefined list. but it can be easily fooled or bypassed by pasting (Ctrl+V) data from other source. So how can i protect to user can't enter wrong data ...
0
votes
1answer
1k views

String match using values in one worksheet with long list (52K) of values from a column in another worksheet

In worksheet 1: I have a fairly short list (~75) of values (text strings) and would like to find all matches of these strings with values from a column in another worksheet (worksheet 2)... these ...
0
votes
1answer
4k views

Writing VBA code to fill down to the end of a range which varies in length

I am writing a macro to automate the completion of a report which is of the same columnar structure (i.e., the same fields in the same columns month after month). However, the number of records in the ...
4
votes
1answer
3k views

Excel countif doesn't work with numbers

in the following example you get output '0' for a strange reason. Can someone explain why this occurs and what I can do about it? (The format of the cells is "text") rows A:A --------- 1 11 111 22 2 ...
0
votes
2answers
146 views

Excel/Spreadsheet - formula for last value in a row?

I'm trying to forecast increasing vendor costs in a spreadsheet. My sheet looks something like this col | A | B | C | D | E | F vendor | 2013-09 | ...
0
votes
1answer
223 views

How to increment rows each time an Excel VBA Macro is run

I have recorded a macro to get a filtered set of 6 numbers and paste them in row 1.I want to get another set of 6 numbers in row 2 when I next run the macro and a third set in row three and so on when ...
-1
votes
1answer
292 views

How to fill Excel 2010 Cells with a recursion idea

What I'm trying to do is have cells auto populate and un-populate dependent on the value of another cell. For instance, Cell B3 has a set value of -0.1, Cell B4 has a set value of 0. Cell D3 is the ...
0
votes
0answers
19 views

Finding Date Created in Office 2007-

I use Office 2007 I cannot find the date a document was created, as in the older versions of Office. I have tried exactly what MS says to do and there are no advanced settings under the 'prepare' ...
1
vote
1answer
139 views

Viewing sheet tabs - Excel starter 2010

In Excel Starter 2010, the sheet tabs aren't displayed down the bottom. There is an option in File->Options->Advanced->Display Options->Show sheet tabs, but that doesn't seem to do anything. Are they ...
0
votes
1answer
3k views

Line Graph Adding Value of Series 1 to Series 2

I'm working on a line graph that contains two lines (each representing two different sets of data) with percentage values for each time period. In the first time period, the value for Set A is 3% ...
0
votes
1answer
4k views

Excel: COUNTIF for Filtered Data

I'm trying do a "COUNTIF" on a list of 24 items (a list of times, in number of hours). For some background, the formulas : =COUNTIF(H2:H25,7) =COUNTIF(H2:H25,"<7") return to me a list ...