**[Solved] growth rate formulas, with a twist** *Summary*: Hi, So here's a tricky one. I tried using CAGR but it doesnt seem to work for me... maybe my logic is wrong. Here is what I want to do: 1 have 37 colu...

**[Solved] formula help in excel** *Summary*: i have 36 columns with an increasing number in each cell left to right... i.e. range is A1 to AJ1 and the numbers start from 7 in A1 and go up to 286 ...

**[Solved] Lookup a column, if matches, give me the last number...** *Summary*: Hi there, We are having a problem in our billing where we hire fleet to other departments, and the data entry person is sometimes not matching up the ...

**[Solved] Days360 is bringing back negative numbers** *Summary*: Can someone look at this? IF(G14<>"",DAYS360(G14,E14),"") G14 is the assigned date while E14 is the date it was created so if it was created on 5/2...

**[Solved] DEBUGGING: Nested drop down in an IF stmt using data validat** *Summary*: Hello! I'm trying to get the following formula to function.. and as it's setup the final [false] parameter keeps showing up, as IF it's ignoring the r...

**[Solved] comparing to dates and times within a timeframe** *Summary*: Hello, First off I have no idea what i'm doing just want to make a large task seem a little smaller I have four columns with dates and times A2: Start...

**I cannot copy and paste a formula in excel** *Summary*: I cannot paste a formula that I have copied. I copy the formula then try to paste it, and it just pastes the calulated amount from that cell. This fun...

**Auto populate rows in Excel** *Summary*: I am using the forumla =IF(ISBLANK(Sheet1!A33),"",Sheet1!A33) to insert info from sheet 1 to sheet 2. The problem I'm having is if I delete a row on s...

**Finding the time between two different times in excel issue** *Summary*: As an example I have 2 columns, A and B - both respectively titled Date and Time. In A2 I have: 4/03/2012 In A3 I have: 8/03/2012 In B2 I have: 20:34:...

**[Solved] Changing worksheet name in formulas** *Summary*: If I rename a worksheet, will the new name automatically be updated in formulas and/or pivot tables that reference that worksheet? If not, is there a ...

**if cell contains text from data validation, t** *Summary*: If a cell contains text from data validation that I created, how can i make a rule to what the adjacent cell will be? Example: If cell B57 has a lis...

**Having problems w/Excel and negative time.** *Summary*: Using columns A - Name B - Time In (formatted to ex. 1:30 pm) C - Time Out (same as above) D - Break (entered as positive time, always .50) E - Total ...

**Grouping rows on multiple criterias** *Summary*: Here's what my spreadsheet looks like: (A) Client Name (B) Date (C) Session Type (D) Formula (If) return Yes when date is in a rang...

**Closest match to text string (text&values)** *Summary*: Hi, I have a column that have a number which I want to find the closest match to another column whic have text&values. Any suggestions, Thank you, ...

**Can you stop formulas updating on a date?** *Summary*: I have a workbook that monitors year to date sales. I have to submit a monthly report to our head office, I have created a seperate workbook for this ...

**VBA To Hide a Row based upon a formula result** *Summary*: Hello, I am looking for help to right a Macro that will look at a cell containing a formula to determine its result and hide the row if the result is...

**multiple if formulas in one cell** *Summary*: Hi, Can anyone help me i'm trying do the following condition in one cell: In cell H2: If J2 = Area1, return a value of 14 If J2 = Area2, return a val...

**Excel Formula to Find a Tab** *Summary*: I have an excel workbook with multiple worksheets. The first sheet is a summary page for a project. The information from the summary page is based o...

**A formula in Excel that will input a value fr** *Summary*: Can anyone help me with a formula or a way around this: I have an Excel spread sheet and on sheet number one column A have a list of names with var...

**Date results showing up as #s** *Summary*: I figured out how to construct a formula that would add 7 days to a date from a previous cell. I am simply using =B2+7. My problem is that the results...

**Excel: Add Data Based On Month** *Summary*: I have the following formula im having trouble with Im hoping someone can help me out A B D ...