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

**1**

vote

**1**answer

32 views

### In Excel, How can I add values in a specific column if I have a checkbox type spreadsheet?

The Excel sheet is linear with column B being the distance walked each day. Across are a column for each participant. As they join the walking group each day, I'd like to keep a count on total ...

**0**

votes

**2**answers

32 views

### SUMPRODUCT with VLOOKUP

I'm trying to get the Product and Sum of what matches in the TC Ref column and the Earn Type.
For example 7926 would be (45.32 x -3) + (45.32 x -3) + (45.32 x -4) for REG and (45.32 x -4) for OT.
I ...

**1**

vote

**0**answers

20 views

### How do I incorporate IFERROR into this formula?

I need to know how to include an IFERROR statement in this formula in Excel 2007.
=VLOOKUP($E3,HSA!$E$3:$G$20,2,FALSE)*$D3
I want the formula to return a 0 instead of an #N/A.

**1**

vote

**2**answers

29 views

### How do I compare two list of data that contains a certain number in Excell?

How do I compare two lists of columns that contains a certain number? Please look at my example below:
Column 1 Column 2
-------------------
300 Room 305
301 Room 306
302 Room ...

**0**

votes

**1**answer

16 views

### How can I create multiple spreadsheets using the value of a column?

I have a workbook (Req_PO_Log_V2.xls) that has all of the expenditures for our repair and maintenance funds from our current FY. The lay out is as follows:
| Date | Req Number | Acct | Vendor # | ...

**1**

vote

**1**answer

31 views

### Find first number greater than x and return another value in that row

I have created an investment spreadsheet. In one column I have the ending balance each year. In another column I have the years.
A B
2000 500K
2001 450K
2003 1.2M
2004 1.5M
How can I display ...

**0**

votes

**1**answer

26 views

### How to find first date after given date in a sorted column

I have two columns of sorted dates in Excel. Given a date in column 1, how do I find the first date in column 2 after the given date?

**0**

votes

**2**answers

72 views

### IF Statement with VLOOKUP

I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...

**2**

votes

**2**answers

41 views

### Counting the Cells in a Named Range without VBA

I have a disjoint set of 9 cells: A1,B3,C5,D7,E11,F13,G17,H19,I23. I have assigned a Name to these cells: MyPicksI have a simple formula to pick the value in one of these cells at random:
...

**0**

votes

**2**answers

40 views

### How do I SUM values in column B based on criteria in column D in Google Spreadsheet? [closed]

I would like to sum all the values in column B based on a criteria measured against another column D in the same row. So, going down the Column B, I should count the value if Column D in that row has ...

**2**

votes

**2**answers

77 views

### Excel 2013 VBA programming

I'll start off my saying I'm trying to save time for a family member who is doing this program manually.
Sheet 1
Column A is a start date
Column B is a projected start date
Column E is a Task Name.
...

**-1**

votes

**1**answer

41 views

### Can I split a spreadsheet into multiple files based on a Row in Excel 2013?

I have a spreadsheet in excel 2013 which have multiple column and rows. I need to send some columns to different people separate files. Please anyone can help me in this. Please try to use macros, or ...

**0**

votes

**0**answers

41 views

### Extracting HTML from Excel to enter in MySQL/Wordpress site

I have a WordPress site and an Excel document. I'm not familiar with Excel formulas so forgive me.
The document contains a lot of names, email addresses and telephone numbers. I want to create a ...

**1**

vote

**1**answer

20 views

### Summing multiple cells that match row AND column criteria?

I've been given a file with 2 years worth of dates as column headers and sales info below. There's also a column that contains Year data. I'm trying to sort by both Year and Day of the Week. I'm ...

**0**

votes

**2**answers

37 views

### Excel Index/Match Sum

I have 2 worksheets in Excel. Both have data from a 2 different databases. The first tab has part numbers and costs (could be different day to day), the second has how many times that part number ...

**-1**

votes

**2**answers

56 views

### If one number then a different number

I have two columns of numbers on a data page, over 500 pairs. And I need a formula for the working page that will insert the second number in “column B” if the first number is in “column A”. So if my ...

**0**

votes

**3**answers

55 views

### Excel macro: Last non-empty cell in a column

This is a followup question to this one.
The following formula can be used to find the value of the last non-empty cell in a column, in Microsoft Excel:
=LOOKUP(2,1/(A:A<>""),A:A)
My ...

**0**

votes

**3**answers

45 views

### How do I import data from 6 Excel Workbooks into one on a daily basis?

I'm needing to be able to pull data from 6 individual Excel Workbooks that are all formatted the same, first line being the same header across all six and then the data starting row 2 going down being ...

**1**

vote

**0**answers

17 views

### Where does the calculation take place? [closed]

In Google spreadsheets, I have quite a big amount of relatively complex array formulas in many cells. That takes ages to complete calculating.
Does the speed of calculation depend on my PC ...

**0**

votes

**2**answers

40 views

### Finding a value in one colunm that matches another column then putting that value in a third column (excel 2010)

All of the values are texts since the are usernames that are from two different systems.
so one column has:
Column A Column B
smit19108 Fred99015
Fred99015 Smit1908
...

**1**

vote

**1**answer

53 views

### Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...

**0**

votes

**0**answers

21 views

### Excel formula If column B starts with… then columns D & E populate from a list

I'm working on a spread sheet where column B is filled with ID numbers. Column D and E correlate directly to the first few digits of the ID number.
Example:
B= 1.1.1 then D= Imaging and E= T.P.
B= ...

**2**

votes

**1**answer

29 views

### Excel Formula - returning data

I have a spreadsheet that has four columns of data.
I want column number four (D) to display the value of column three (C) IF the number next to it in column two (B) matches ANY number in column one ...

**0**

votes

**2**answers

65 views

### Excel 2010 Table auto expand/formula copy not working

I have a table with around 2k rows, for which I originally needed any formulae copied down into new rows, when they are added. To achieve this, I created a table from the data as many threads stated ...

**1**

vote

**1**answer

20 views

### Applying reference to another sheet to all cells

I have LibreOffice Calc file which has 2 sheets.
I wanted to reference Sheet1 from Sheet2, so I wrote function =Sheet1.A1 in Sheet2 cell A1.
How do I apply this to all cells on Sheet2? (Sheet2.B5 = ...

**0**

votes

**0**answers

21 views

### How do I copy/referrence last value of the column from another file and worksheet

I have two spreadsheets - one is the inventory sheet that gets updated with sales and purchases, and the other spreadsheet is where I want to reference or copy the ending inventory as soon as it gets ...

**0**

votes

**1**answer

21 views

### I need the number in a cell to countdown when data is entered into other cells.

I'm making a sheet to keep track of the number of software licenses.
In cell B1 I have the number 35 representing 35 licenses. As they are assigned to systems in cells C5-C40 I would like the total ...

**0**

votes

**0**answers

12 views

### How can I Collate and create totals of a range of transactions in iwork Numbers

ColumnA ColumnB
Dave 10
Dave 10
Peter 5
Susan 5
Dave 5
Peter 5
I would like to create new table to read down ColumnA, create a new list with no Duplicates and Total up the Values ...

**0**

votes

**0**answers

46 views

### excel - how to count number of names in a column, name is specified in a cell

I have two worksheets, "Clients 2014" and "Receipts 2014".
The receipts have client names for each row (each row is a receipt).
The search key is in the "Clients 2014" worksheet.
I want to ...

**0**

votes

**1**answer

20 views

### How to return the name of uniquely named sheet

So I've searched high and low and cannot seem to find an answer to this question. Spent almost two days trying every thing I could find on line, but none were specific enough to my situation. Without ...

**0**

votes

**0**answers

16 views

### Memory limits in Excel (functions lookup)

can I obtain an advice how many Excel files with what size can I have opened at the same and link with functions (lookup) in Excel 2010 32 bit system?
Is there a way to predict how fast the ...

**1**

vote

**2**answers

67 views

### Excel formula to convert date formats

Assuming I have cells that have text values mentioned as:
02/23/15 to 03/01/15
Can I use excel functions to convert this to something like
23-Feb-15 to 1-Mar-15
So far I have looked at formula ...

**1**

vote

**2**answers

41 views

### Multiple IF Statement

I have a question about IF statements.
I wanted to use VBA, but the other guy I am working with doesn't know how to do it, so I am trying to only use worksheet formulas. So, I figured the best way ...

**1**

vote

**2**answers

49 views

### How to I simplify code that combines information and adds up values for certain columns?

I am revamping some VBA code that was done 15 years ago that someone else created. I have to add more code to fit our needs but I exceed the amount of code allowed to run.
I have a Products in ...

**0**

votes

**2**answers

33 views

### Excel Equation: How to skip cell value if row header contains certain text

So I have a workbook for tracking my inventory in real time. It's a really bad bandaid for a problem I cannot have addressed at the moment, so bare with me.
The issue is, I want to have my inventory ...

**0**

votes

**0**answers

35 views

### Why is VLOOKUP returning wrong cells as data is refreshed?

I am creating a spread sheet which works out my material requirements based on future order forecast. I have live data in the workbook which represents the material on stock and they're location. I ...

**0**

votes

**0**answers

29 views

### Rearrange columns from fiscal year to calendar year in OpenOffice spreadsheet

I have twelve monthly columns plus a total column in a spreadsheet that was originally created for an April through March fiscal year. Now I need to rearrange the columns for a calendar year, without ...

**1**

vote

**1**answer

42 views

### Excel 2007 how to put a text message in a cell if multiple cells are filled with data

I am trying to put a text message in a cell (say c1) if multiple cells in column A have data in. The cells in column A are A1-3, A5, A6 A8 and will have data from 1-5. I only want the text message ...

**0**

votes

**0**answers

46 views

### IF Function Combined with Median date range check across multiple sheets

I am trying to create a formula that checks if a single cell date falls between a beginning and end date using the median function, and if so returns a value. I have multiple sheets I would like the ...

**0**

votes

**2**answers

32 views

### Excel 2007 - formula to display last updated cells

I have 6 cells, A1-A6 in Sheet1.
A1,A3,& A5 contain numbers 1-3
A2,A4,& A6 contain the date the numbers changed.
A1 & A2 will be filled first. I want to display both cells in Sheet2 in ...

**0**

votes

**2**answers

33 views

### How can I create an IF-THEN statement in Excel with two variables?

A B C(Output)
----------- ----------- ------
| 65 | 0 | 2 |
----------- ----------- ------
| 31 | 99 | 3 |
----------- ...

**0**

votes

**1**answer

27 views

### Use AVERAGEIF across multiple cell ranges in a worksheet

I am using AVERAGEIF using the following to return the answer
=AVERAGEIF('Sheet 2'!H3:K10,I9,'Sheet 2'!K3:K10)
This works well if I have all the information in one sheet, however I have the ...

**3**

votes

**1**answer

43 views

### Using a Defined Name in a Formula

I have a set of cells with values:
A1,B3,C5,D7,E11,F13,G17,H19,I23
I have a formula to select, at random, the value stored in one of these cells:
...

**0**

votes

**1**answer

33 views

### Why doesn't this array formula work when cell reference contains a formual?

I have created an array formula (first formula below) to return the nth value in Data!B:B based on the date value in B4. The formulas appear to work when I have the date in B4 but if I use the second ...

**1**

vote

**1**answer

68 views

### Excel: delete row if empty cell condition is true across multiple columns

I have a data set in Excel that i need to filter out rows where no data exists (i.e.- empty cell). It isn't as easy as deleting a row that has an empty cell in one column but rather if there are empty ...

**0**

votes

**1**answer

34 views

### Excel 2010 - VLookup -

I have two identities associated with one unique value in the table. I need to pull both the values in another sheet using vlookup - is that possible.
Here is the example:
Id Owner Name
A1 Owner 1
...

**0**

votes

**0**answers

25 views

### Excel no longer auto update my calculation?

My excel sheets does not auto update my formulas. It did up to a point and now it no longer do. Just checked the settings under file and it is set to auto? Can some please help. Sheet to big to redo.
...

**0**

votes

**1**answer

87 views

### How do I copy multiple rows to another sheet based on selection with checkboxes in Excel?

This is a screen clip of 2 sheets in Excel 2013. What I am trying to do is that if the checkbox corresponding with the row is checked, the text in the row shows up in the second sheet. There will ...

**-1**

votes

**1**answer

31 views

### Excel 2011 for Mac - formula property dropdown list missing

Basically missing the dropdown properties list on Excel 2011 for Mac. How do I enable/show it?
I've already:
ticked the "show function ScreenTips option" under Excel Preferences > View > ...

**2**

votes

**1**answer

49 views

### How to count number of distinct values containing specific text

I'm not sure if I've phrased that question well so I'll elaborate.
I have 160 lines of file numbers, many of which are duplicates. In each file number there is a value that determines the year the ...