I have a formula in cell C5 that displays the percent change between two values in the same column. The formula reads =-(C10-C9)/C10. When I insert a in...

How can I set up one formula to randomly give me a number from multiple ranges? For example, I have 2 ranges. One is 105 though 128 and the other is 244...

For example if you typed 7 in one cell but in another cell where cell one = the 2nd cell you want it to appear as 7th not 7 ???

Hi, this is my scenario... I have a table with 2 (more but they are irrelevant) columns: Column # and GST In the # Column I have numbers 1, 2, 3 etc and I...

i have a list of email addresses in the first column on 10 worksheets. some of them are duplicates. is there a formula to compile a list of all of the emails...

I would like to make a short spread sheet that would for example, start with a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or so...

Hi I have one pivot table, source data sheet is not available. it has Page filter month Customer ID fields + Sales amount + total sales + % sales to total in...

i'm working on a long (approx 5000 lines) data sheet and i have a different list containing erroneous values that relate to a particular row in the 1st data...

I don't know if this can be done or not.... I have one cell B4 that is a dropdown list through data validation. Then another cell, A15, that looks at B4 and...

I have a task to analyze GPRS usage on a company's monthly cellular bill for each individual phone. There are many telephones in the fleet and the rawdata...

I am importing a spreadsheet with two columns; ID and Code number. I want to convert these into readable text. Each combination (about 90 potential...

Hello - I am working in Excel 2007 and am having trouble limiting the values for the criteria to an exact match only. The function is summing all criteria...

I need to perform a calculation on my master sheet that will be the same and reference the same cells across numerous worksheets, actually I will have a...

I have a formula to enter ending with the letter C. However, Excel will not accept this type of formula. I need help with this because I am working on...

I was given a function that allowed me to count unique semicolon separated values in aggregate column cells. I want to be able to couple this with the...

I have aggregated data in columns that were imported from web forms and are separated by semicolons. The questions was select your preferred day of week...

I'm setting up a spread sheet for bill of materials. Let's say I have 3x3x1/4 material at 1' 10 3/8" each and 3x3x1/4 at 5' 4 1/8" each. I want Excel to...

I keep daily attendance and grades in a workbook. Each worksheet has a date as its tab. Worksheets are formatted identically with Student names,...

I have the worksheets with the following column headings: Name Acct1 Acct2 Acct3 The rows are listed for each week: 1/6/08 1/13/08 1/20/08 1/27/08 The...

I need to check for three (or more conditions) and need a different value returned for each criteria. For example: DATA Wanted result: 1 ...