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

learn more… | top users | synonyms (5)

0
votes
2answers
36 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. ...
0
votes
0answers
38 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 ...
1
vote
1answer
23 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
2answers
25 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 ...
0
votes
0answers
22 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 ...
0
votes
1answer
17 views

Count values in column B based on criteria in column D in Google Spreadsheet

I would like to count all the values in a column (Column B in this case) based on a criteria measured against another column (Column D) in the same row. So, going down the Column B, I should count the ...
-1
votes
1answer
25 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
0answers
18 views

create an excel sheet to schedule employee annual planner

I want to create an excel sheet to schedule employee annual planner. If anyone submits leave application, while entering i need to find anyone applied for these date range. And also compared it with ...
0
votes
0answers
21 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
1answer
12 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 ...
18
votes
3answers
101k views

What is the Excel hotkey to re-calculate all formula in sheet?

I have a sheet that contains many formulas. But they do not recalculate automatically when I change input. I'm looking for a hotkey, that can re-calculate the sheet. According to this page, F9 ...
-1
votes
2answers
54 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
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 ...
1
vote
3answers
2k views

Display multiple cells if data on another workbook contains “X”value

I export a complex report daily and I transfer that information manually into another excel sheet. My question is: In workbook 1, can I get a group of cells in a row to display the text in workbook 2 ...
0
votes
3answers
26 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
3answers
35 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
0answers
16 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
2answers
27 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
1answer
45 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
0answers
18 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= ...
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
1answer
27 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 ...
1
vote
1answer
12 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 = ...
-1
votes
0answers
37 views

Office 2013 Data Extraction from multiple workbooks [closed]

I generate numerous time sheets for my client on a daily basis (varies from 6-12 daily) and usually work is performed at least 6 days a week. I need to populate the total number of hours (ST and OT) ...
0
votes
2answers
24 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 ...
0
votes
0answers
37 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
2answers
2k views

Excel INDIRECT function and conditional formatting - highlighting a row

I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
0
votes
1answer
2k views

In excel how to do a 'sumif' function that is dynamic to a changing column

I'm trying to use a formula to do a sumif of a column of monthly data that changes depending on the current month. For example say I am entering this formula in column A of tab 2. Since it is ...
0
votes
0answers
20 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 ...
4
votes
3answers
16k views

How do you include an OR inside a SUMPRODUCT function, in Microsoft Excel?

How do you include an OR inside the sumproduct function in Excel? I currently use two sumproduct formulas because I have two variables I want it to count: ...
1
vote
2answers
47 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
1answer
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
0answers
43 views

Referencing a cell from another sheet [closed]

I've got a sheet named 'No.of Mails Data'! where the data is and i want to use my formula on another sheet =OFFSET(INDIRECT((CONCATENATE("B",(COUNTIF($B:$B,"*")-6)*6+2))),,,30,1) this is the ...
0
votes
0answers
10 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
2answers
2k views

Complex rota hours calculation in excel

OK so there are a number of different shifts in operation here and I want a total hours formula. problem is the rota is written using a number of different notations for different shifts some are ...
0
votes
1answer
6k 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 change from -4 to +4. A change ...
0
votes
1answer
19 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
0answers
17 views

Update formula ranges when adding new rows to a spreadsheet [migrated]

I have a Google Spreadsheet in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses: ...
1
vote
2answers
44 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
2answers
42 views

Excel Convert the correct Date type

I'm currently following the date type dd/mm/yyyy i need to have another row showing the month in mmm type. E.g. From 13/09/2014 to SEP My formula is =Text(A2, "mmm") which is the correct formula, ...
0
votes
0answers
15 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
2answers
38 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 ...
0
votes
2answers
26 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 ...
3
votes
4answers
12k views

Merging columns in Excel with “;” separator

I'm new here and I hope to seek for your assistance on converting data format of my excel to csv. This is my raw data in excel in different row and cells: A B C D E F 1 2 3 4 5 6 ...
7
votes
4answers
25k views

Is there an Excel function to create a hash value?

I'm working with a number of data lists that are keyed by document name. The document names, while very descriptive, are quite cumbersome if I need to view them on (up to 256 bytes is a lot of real ...
0
votes
0answers
33 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 ...
2
votes
1answer
256 views

VBA - Arrayformula to a range stored as array variable

I need to apply a formula array to dynamic ranges in my spreadsheets, which for a fixed size range works fine using for example: Selection.Offset(2, 0).FormulaArray = ...
4
votes
2answers
3k views

How do I download a stock price in Excel 2013? Is there an equivalent to Google Doc's GoogleFinance spreadsheet function?

In a Google Docs spreadsheet, I can use this cell formula: =GoogleFinance("GOOG", "price") to download the latest price of a stock. Is there an equivalent function in Excel 2013? Earlier versions ...
1
vote
1answer
35 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 ...
1
vote
0answers
38 views

Excel for Mac 2011 move column 2 in sheet 1 to column 1 in sheet 2

I would like to move column 2 into column 1 for each successive sheet, one sheet per week, automatically. Is that possible? I do it with this formula ='1st week'!D2 and manually changing '1st week' to ...