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

learn more… | top users | synonyms (5)

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