Questions about using in-cell functions/formulas in spreadsheet software.

**0**

votes

**1**answer

139 views

### How to get list of cells that match criteria in Excel 2013

I have three columns in an Excel 2013 spreadsheet. One is an ID, one is a reference column, and one is a referenced by column. Some rows reference other rows, and some rows are referenced by other ...

**0**

votes

**2**answers

85 views

### EXCEL: If function and refering to cell containing operator

I don't know how to handle a cell which contain an operator and number.
Let's say I have 3 rows:
2
0,6
<0,1
In column B I have IF function which checks the number if it's greater or less than ...

**2**

votes

**1**answer

255 views

### excel vba: to export multiple excel sheet into its designated jpg file

I am working on an excel vba command to export multiple excel sheet to its designated jpg file.
I have 16 worksheet in one excel workbook and it would be best to export each sheet into jpg format.
...

**0**

votes

**1**answer

616 views

### Excel formulas for budgeting sheet (or VBA code)

I'm (an amateur) and I'm creating a sheet to help me with Budgeting. I've got bills that I can enter, but that come at a variety of different intervals. I'd love it if I could enter the total from ...

**1**

vote

**3**answers

9k views

### In Excel, how do I copy a formula down or over, skipping cells?

Ex: =A1+A2 next cell down A3+A4 next cell down A5+A6, not A1+A2, A2+A3, A3+A4. I am trying to net cells, some are exact duplicates, some are not

**0**

votes

**1**answer

272 views

### Globe Software Atlas Error: AtlasTable function “Failed to build Atlas forumla”

We have an Atlas Template (Excel document) containing a number of formulas. One of these formulas is causing the exception message:
Failed to build Atlas formula: =AtlasTable("Production ...

**2**

votes

**2**answers

66 views

### How to deal with lots of brackets in a formula?

Say, I have a formula like this (in LaTeX or Maple or other text system):
Result: ...

**0**

votes

**1**answer

516 views

### Two related cells: give a value in one, calculate the other, and vice versa? [duplicate]

How can I have a cell that uses the literal value written into it, or calculates its value when no literal value was given?
For example:
I have two columns: column B with a price including VAT, and ...

**0**

votes

**2**answers

663 views

### Excel 2010 line chart; limiting data points to fewer than the max

In Excel 2010, how do I limit the number of data points on a line graph to the latest (or last) 4 data?
I update the spreadsheet often, but only the latest data is graphed and reported.

**1**

vote

**1**answer

64 views

### Excel 2010 Recordset - How to insert a sequential number into an extracted ODBC recordset based on unique identifer

ColumnA ColumnB
EnquiryNo VisitNo
1804 0
1804 0
1804 0
1805 0
1806 0
1807 0
1807 0
Hope you can help as I am stumped!
My excel ...

**0**

votes

**2**answers

8k views

### Excel-Overcoming #VALUE error with FIND function

In cell A1 I have entered "Apple". In B2 I enter the formula =FIND("Apple",A:A). However I keep getting #VALUE error. Can anyone explain this and how do I overcome it.

**0**

votes

**1**answer

134 views

### Excel 2010 Formula not working - SUM IF

I have this excel table and I want to SUM some values from a column depending on what value they have on the column to the left.
The values from the right that have "Overall Results" on the left, are ...

**1**

vote

**2**answers

21k views

### Excel Formula To Get First Non-Zero Value in Row and Return Column Header

I am attempting to find a formula where I can look at a column range within a row and return the column header in that row where the first non-zero value occurs, moving left to right.
Below is a ...

**2**

votes

**2**answers

89 views

### Advanced (?) Excel filtering

First of all, I'd like to admit that I don't really know anything about Excel, but I have tried to look up a solution to this in Excel books and Googling.
Here's what I'm trying to do:
I have a ...

**2**

votes

**1**answer

91 views

### Excel lookup / value formula

Ok hard to describe this one.
I want to be able to create a formula where part of the formula is populated by info in another field.
e.g.
Sheet 1
A1 = TXT - A2
A2 = number - 1599
Sheet 2
A1 = ...

**0**

votes

**1**answer

419 views

### Excel 2013: VLookup for cells that share common characters within cell but are both surrounded by other non-matching text

I am pulling information from 2 different databases. The databases use different naming protocol for the exact same item/specified placement however they always have certain components of the name in ...

**0**

votes

**1**answer

127 views

### Compare two excel spreadsheets

I have a spreadsheet that is about 12 columns wide and 5k lines long. I get a new sheet each week and I need to compare the two to determine; 1. if a new line has been added, 2. If an date in the ...

**0**

votes

**2**answers

946 views

### How to generate weekly dates from bi-weekly pay period in Excel

I'm trying to convert bi-weekly pay period to weekly dates. Lets say I have 3/2/2012, 3/16/2012, 3/30/2012 and some gaps and then again biweekly dates.
generate
3/9/2012, 3/16/2012, 3/23/2012, ...

**-1**

votes

**1**answer

249 views

### How to get data from separate worksheets displayed in a single separate worksheet

I am working on a spreadsheet in Microsoft excel 2010. In the spreadsheet I have 3 worksheets. These are known as:
1st
2nd
Cases
Now in the 1st and 2nd Worksheets, there is a table at the bottom ...

**1**

vote

**2**answers

624 views

### How to find specific text syntax format in a cell with an Excel function?

I am looking for a cell formula to find/identify/validate if an adjacent cell contains characters in the correct format.
If there is a character "|", then it must be preceded or followed by any ...

**0**

votes

**1**answer

245 views

### How to fill sequence in Excel from ranges given in another sheets?

I have an Excel sheet where two columns (say J and K) among data in sheet1 are as follows:
J ------------ K
1 ----------- 25
26 --------- 50
101 ------ 150
Which are some ranges. ...

**0**

votes

**2**answers

2k views

### How to extrapolate or predict a project completion date

I have a few data points consisting of a percentage completed and a date. I would like to be able to predict the expected completion date based on the progress made so far.
If this cannot simply be ...

**0**

votes

**3**answers

9k views

### Comparing columns in two different excel sheets and if they match copying third column

I have limited working knowledge of Excel and I hope someone will be able to help me with my problem.
I have two different work sheets (say F1 and F2) with last name in Column A, first name in Column ...

**0**

votes

**2**answers

109 views

### How do I determine if a value is between range of values specified in two columns and return another value from the row where condition is true?

I have a value that I enter in cell B5. I need a value returned from column C and the corresponding row where the value is between minimum values in A10:A12 and maximum values in B10:B12. In the ...

**0**

votes

**1**answer

216 views

### Excel 2010 - Show cell contents - wrong number appearance

I was trying to create a simple function in Excel VBA editor. When I click on a cell within the certain range, I want to copy its value into another cell I have set.
Private Sub ...

**0**

votes

**2**answers

89 views

### having cell show a paticular number if the answer in the formula in the cell is a certain number

so I don't know if it's possible but I want to have a cell show a particular percentage in the formula I put in the cell comes up with a particular answer. for example, if I put in the formula =6/3 ...

**0**

votes

**1**answer

773 views

### Line chart from multiple tables in Excel 2013

I have two sheets, "Graphs" and "Data".
In "Graphs" is a line chart with a single line that gets X and Y values from tables in "Data". I want the chart to be updated automatically when I add ...

**7**

votes

**2**answers

695 views

### Formula for finding 'near perfect' matches [duplicate]

I have a list of +-8000 items which is the result after applying numerous techniques to remove duplicates (the list started at over 10000 items).
I now have the following issue -
Example
1. Jack ...

**0**

votes

**1**answer

56 views

### how to sum the amount of cells with the same number in a column - Microsoft Excel 2010

My english isn't that good, I hope you understand what I wan't to accomplish
I have a column (A) with different zip codes ( total of 3583 rows). I need a formula/function to go through each cell and ...

**1**

vote

**0**answers

46 views

### How can I move columns based on the column header title to another workbook?

I have to average grades based on each objective for a new report card we have to complete this year. Column one has students names, each additional column will have the objective associated with the ...

**1**

vote

**2**answers

47 views

### Excel Conditional Summing

I want to create a formula so that I can keep track of how many feet get out of a drill bit. The data will be arranged in this way:
I want to show results of the total footage drilled by:
Any ...

**2**

votes

**1**answer

156 views

### Excel VLOOKUP using results from a formula as the lookup value

I have a cell that I must remove the first 2 characters "RO" for each value in a column on a sheet called RAW DATA and put into a cell on a sheet called ROSS DATA. Some of the values in that cell have ...

**0**

votes

**1**answer

112 views

### Excel: Look up function for combinations of cells in a single column

I'm looking to find the number of times a certain combination of values appears in a single column, I was hoping to do this in Excel but I'm starting to think it may not be possible.
As an example, I ...

**1**

vote

**1**answer

210 views

### Excel access.Vlookup? IF?

What I am looking to do, is to move stuff from one excel sheet to another sheet, in the same workbook.
We will call the sheet with the data the "suppliers list" and the sheet where I want it to go, ...

**0**

votes

**2**answers

2k views

### Conditional formatting of a cell based on value in 4 adjacent cells

I'm trying to get a cell C3 to highlight using conditional formatting, but based on a value in 4 other cells.
If 4 continuously adjacent cells (e.g. AS3, AT3, AU3, AV3) contain the X value only then ...

**3**

votes

**2**answers

152 views

### Flatten Excel Formula (2007)

Say cell A1 has the formula A2 + A3
and B1 has the formula B2 + B2
and C1 has the formula A1 + B1
I need an easy and quick way to create the formula for C1 in the flattened state..
i.e.
(A2 + A3) ...

**1**

vote

**1**answer

155 views

### If A1>1, I would like the next 3 cells to be red, i.e.a2,a3,a4 red. But if A2>1 I also want the next three cells red

What I would like is: if ANY cell has a number greater than 1 - then the next 3 cells TO THE RIGHT trun red
Is there a way of doing this, without me having to type the formula in to every single ...

**1**

vote

**3**answers

64k views

### How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...

**-1**

votes

**1**answer

61 views

### IF Statement Budget File setup for Monthly Amounts

I am working on a budget formula and am stuck on the termination date, I can't get the formula to work if a tenant will remain all year (no termination date). It works perfectly if a tenant has a ...

**7**

votes

**3**answers

12k views

### In Excel how can I sum all the numbers above the current cell?

I want to have a column in Excel that consists of a header, a bunch of numbers, and then have the sum of those numbers at the bottom. I'd like the sum to adapt to the insertion of new numbers above ...

**0**

votes

**1**answer

97 views

### Preparing an Excel 2010 workbook for Excel 2013 compatibility

I'm going through an important workbook currently in Excel 2010 to make sure it's fully compatible with Excel 2013. I found a list of changes to the object model in 2013, but it didn't cover your ...

**1**

vote

**2**answers

871 views

### Cumulative average using data from multiple rows in an Excel table

I am trying to calculate a cumulative average column on a table I'm making in Excel.
I use the totals row for the ending cumulative average, but I would like to add a column that gives a cumulative ...

**-4**

votes

**1**answer

1k views

### how do you ignore empty cells?

I'm using this function to rank data:
=SUMPRODUCT(($B$2:$B$11>B2) / COUNTIF($B$2:$B$11,$B$2:$B$11&"")) + 1
This version assigns 1 to the highest value
and sequentially increasing ranks to ...

**-1**

votes

**2**answers

123 views

### If A:A is more than -500 and less than -400, then sum values in corresponding rows in B

I have a list of locations with corresponding values and need to sum the values for a range of locations.
Example
middlePeak tags
-499 107
-495.5 114
-493.5 ...

**7**

votes

**3**answers

23k 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

**2**answers

300 views

### Multiple conditions in if statement on non-contiguous cells in Excel

I would like to perform an if statement with conditions on the values of multiple non-contiguous cells, something like
...

**1**

vote

**2**answers

354 views

### Excel formula/VBA to detect a property of a group of rows

I have a large dataset in an Excel sheet where:
column A: quote number
column B: opportunity number
column C: sales order number.
One quote number will have multiple opportunity numbers. A sales ...

**1**

vote

**2**answers

323 views

### Average using Elapsed Time processing a number of docs

I process documents and want to get a formula showing the average time to process each document.
Here's my data:
number of docs processed (column G)
start date/time (H)
end date/time (I)
elapsed ...

**1**

vote

**1**answer

165 views

### Google Spreadsheet. Retrieve only one cell from ImportData-result [closed]

I have this function:
=ImportData("http://ichart.yahoo.com/table.csv?s=AAPL&a=0&b=7&c=2013&d=0&e=7&f=2013&g=d&ignore=.csv")
...which returns how a given stock was ...

**0**

votes

**1**answer

924 views

### Excel summing named range

I have a workbook with many sheets in it. I want to sum column C2:C50 on each sheet. However, in the future I anticipate having to sum the range C2:C?, and rather than have to go into each sheet to ...