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

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

**1**answer

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

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

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

**1**answer

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

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

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

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

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

**3**answers

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

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

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

**1**answer

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

**2**answers

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

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

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

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

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

**1**answer

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

**2**answers

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

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

**2**

votes

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**3**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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