Tagged Questions

0
votes
0answers
10 views

Runtime Error 1004 Unable To Set the Locked Property of the Range Class

Have searched around but I could not find the answer. The only thing it pointed to was merged cells however I do not have any. If someone wants to look at the file, I can only email as its too big to ...
1
vote
1answer
20 views

How to calculate values between three cells using conditional calculation

I am new to this forum and not very new to Excel (not in depth) I have to perform a calculation for three cells by conditional calculation. so here is the scenario Column Name: Total Area (Cell ...
-2
votes
2answers
120 views

Nested IF formula

I want a formula that will capture the following three scenarios below. In column S, I have Orange in cell S2, Mango in cell S3, Grape in cell S4, Pawpaw in cell S5, Onion in cell S6, Apple in cell ...
0
votes
1answer
131 views

Excel Formula for filtering data from one sheet to another

I have table that have the following columns (Agent Name, Client, Policy #, Premium) with the name of agents repeating several times since they have multiple clients... I don't want to give all the ...
0
votes
3answers
101 views

change link cell formula across sheets

I have a workbook named "stu", it has 1 to 30 sheets. In cell H4 I have linked a formula: =[sub.xlsx]Sheet1!$B$2 in sheet1: cell H4 the formula in cell H4 should be =[sub.xlsx]Sheet1!$B$2 in ...
0
votes
1answer
161 views

Excel formula sorting data by date but group by column value

Morning people I've been roped into helping someone with an excel sorting issue and I've got myself a bit stuck to be honest. I need to sort a spreadsheet by date (oldest to the newest) but group ...
1
vote
1answer
315 views

How do I set up Simpson's rule in Excel?

I know there are example spreadsheets online, but I look at the formulas and don't quite understand what is going on. I know the formula for Simpson's Rule but I don't know how to implement it in ...
1
vote
3answers
51 views

Complex Summing Values in a Cell

Let's say I have formula result that returns this +10+5+1+40, as text. I want to then sum the those numbers to get the total. The result could be any number of values, so like +2+5 or +10+5+7+1+8. ...
3
votes
2answers
269 views

Is there a way to express a complex Excel formula in terms of final (non-formula, value-only) cells?

I have a very complicated Excel spreadsheet (formulas accessing cells with other formulas across multiple worksheets) that in the end computes a single cell (output) with input from several other ...
1
vote
2answers
157 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 ...
1
vote
2answers
204 views

Comparing Two Columns in Excel, Returning a Third

I've hit a bit of a brick wall in my Excel-ing. Below is the example and explanation. Sheet 1: Column A | Column B | Column C | Column D _ Name _ | _ Date ._ | _ Cost .._ | _ Code _ ...
2
votes
1answer
2k views

How do I extract excel data from multiple worksheets and put into one sheet?

In a workbook I have 7 sheets(Totals and then Mon to Sat),I want to extract rows which have the word "CHEQ" in its cell (this is a dropdown list with two options-CHEQ/PAID)from all sheets. On my front ...
3
votes
1answer
229 views

What does “calcs” formula do in Microsoft Excel?

I encountered an XLS file with this formula in some of its cells. I searched the web for information on the formula, but I couldn't find anything. Could you help? The formula in question is: ...
0
votes
2answers
451 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 ...
-1
votes
1answer
1k views

Calculate age in days/months/years in OpenOffice

In need to find the age in days - months - years in OpenOffice. There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates. Age Calculation ...
0
votes
1answer
270 views

Excel 2010: Giving another cell value to an “x” (check) in a cell

Hopefully I'll be able to explain clearly what I would like: I have a spreadsheet about a car pool. I have to put an "x" (check) in a cell when there are seats available to transport people, but I ...
1
vote
1answer
457 views

merge cells with formula skip duplicates

Our Goal is to merge the names (B) when the data in A is equal. The formula below looks at the next line (A), if it's the same, it merges data (name) from B. The formula is in C, so the result of the ...
2
votes
2answers
3k views

Excel: How to return the last Row Number that a contains a specific string?

In excel, is there an excel formula I can use to populate Column B (in my example below) that will return the last row number that contains a specific string, before the current row? The data is not ...
0
votes
2answers
202 views

How do I get Excel to automatically replicate functions across the spreadsheet?

I have a spreadsheet where I'm doing a whole table of calculations. I'm playing with the calculations and seeing what it does to the data. I expect to change the calculations dozens of times (at ...
1
vote
1answer
434 views

How would I create a function in Google Docs (or Excel) to evaluate column a and return column b value.

I'm using google docs speadsheets to create a dashboard. I have two columns of data. I want to have a cell evaluate Column One for a specific name(for example, "Agency A") and return the value in ...
0
votes
2answers
8k views

Compare Two Columns (from two different worksheets) and show result of another column - excel

I have this scenario: Worksheet 1 with Column A only Worksheet 2 with Column A and B I have to compare Column A (Worksheet 1) and Column A (Worksheet 2). If a value in Column A (Worksheet 1) is ...
3
votes
3answers
6k views

How to separate number by its decimal point in Excel/Calc?

I've got a number in a spreadsheet like so: 28.686279 When I open this sheet in either LibreOffice Calc or Microsoft Excel, is there a formula function that returns the "whole number", I.e. 28. Also, ...
0
votes
1answer
389 views

Count the number of contiguous empty cells at the end of a row

I have rows of data, some cells are empty and some contain a number. I need to identify how many contiguous empty cells exist at the end of each row. I've tried using a string of nested IF ...
2
votes
5answers
8k views

Using excel, how can I count the number of cells in a column containing the text “true” or “false”?

I have a spreadsheet that has a column of cells where each cell contains a single word. I would like to count the occurrences of some words. I can use the COUNTIF function for most words, but if the ...
1
vote
1answer
978 views

Excel: VLookUp solves a potential Nested IF problem

I manually enter numbers on one cell according to text values in the cell adjacent to it. Is there a way to use the IF function to help me manage this? The text is automatically generated with a ...
2
votes
2answers
3k views

What is an excel formula that will return me the last row number of a cell within a range that contains specific data?

I have a spreadsheet that will default with values of "No". Over time, these values will be changed to "Yes". I need a formula (no VB, please, VB is useless to me) that will get me the row number of ...