Functions

I want to add formulas from multiple sheets to master form
How do I add formulas from multiple sheets in a workbook to a consolidated worksheet? ... 12 Apr 2010 23:41

Lose Formatting
We have a pretty intense Excel Workbook that we use on a daily bases. We are currently running MS 2007 but this Workbook is running in 97-2003 because we just changed over about 6 months ago. The issue is that in the past week the this file keeps losing it format. Can't seem to figure out why. ... 12 Apr 2010 18:09

Need to extract specific data from a text column
VFLE_VT_1CAAGK_790006_BH4A004M02_STALVTBAKAF From this string I may need to extract 1CAAGK or 790006 or BH4A004M02 Not all rows of data are consistent in the wording however they will have a 6 digit alfa string starting with a 1; a 6 digit string starting with 7 or 8 and a 10 digit alfa/numeric with no spe... 12 Apr 2010 19:16

Combining text from multiple cells
Help please. I'm trying to combine text from multiple cells using the following formula. =B3&" / "&C3&" / "&D3&" / "&E3&" / "&F3&" / "&G3 Column I is where I am combining what is in these cells. The above cells contain formulas which I am using to QA certain data. They can return things like "Low Yield", "... 13 Apr 2010 09:29

Counting with 2 criteria
I need to be able to pull counts from a frequently updated list based on associate's name and status of order. -- Amethyst ... 13 Apr 2010 13:58

Nested IF(OR(AND) Statement with Two AND Conditions
I am using Excel 2003 and could use some assistance with a complex Nested IF statement. Here is the criteria: IF Salesorg=NAW1 AND Salesdivision=N4 AND SalesOffice=NWSA, then Group=UB except when CustomerNbr=90000000 OR 90000001 OR 90000002, then Group=BA. I have tried several different variations of Nested I... 14 Apr 2010 11:04

Can I color a cell with "If" formula
I would like to have the cell turn a certain color with an "If", "Then" formula. Is that possible? ... 12 Apr 2010 15:55

Can I use Sumproduct with the LEFT Function?
Hi, I'm using xl 2007. I need to sum figures in column B if the relevant cell in column F has an entry that starts SM. I was trying to use SUMPRODUCT but I can't seem to get the right way of using the LEFT function to stipulate when to include the figure in col B. I was hoping not to use an array formula just b... 13 Apr 2010 15:06

visible cell only
I'd like to use the PERCENTILE function in a list that has been autofiltered and get the results based only on the visible cells. I've used SUBTOTAL in order to get count, average, min and max. But I need to get the .25 and .75 percentile figures for the filtered data (visible cells only). I've scoured the... 13 Apr 2010 00:47

Combining Cells
I have 4 cells that I need to combine into one cell. One cell has a time in it. When I combine cells it does not come up as time but a fraction. A1 8:30 B1 A C1 Cards D1 Indians My formula is =+A1&" "&+B1&" "&+C1&" "&+D1 I get this 0.354166666666667 A Cards Indians I want 8:30 A Cards Indians ... 12 Apr 2010 14:48