Functions

Show formula result in another sheet
sheet1 A:A contains a formula with some cells returning a value sheet2 A:A references sheet1 A:A with a simple formula: =sheet1!A1 above formula filled down in sheet2 A:A the problem is it is not showing the results from sheet1 anyone know why that should be? ... 15 Dec 2009 17:51

Concatenate Cells
I am having trouble with a formula to concatenate the descriptions into 1 cell for each S/C #, some have 2, 3 of 4 cells. Material No. Full Description 904120016 VALVE,SOLENOID, 240V 50HZ, HERION, P/N 9301800-0201, FOR GAS SAFETY SHUT OFF AND VENT BALL VALVES, ON ALUMINA KILNS 907010005 CABLE,BUILDING, 7/0... 16 Dec 2009 02:35

Sorting a text strings but omitting preceding "A" or "The"
I need to sort text strings the may begin with "A" or "The". In these cases I would like for the sort to ignore the "A" or "The" and sort based off the second item in the string. Can you set preconditions to the sort? Example: The Big Blue Boat A Tree Grows in Brooklyn Giant Four Score is Twenty Times Four ... 15 Dec 2009 17:51

Count occurences of same zip codes
I am working on an in-house member density spreadsheet in Excel 2003/2007. Here is the test data 14815 14815 14891 19880 I would like result to be: 14815 2 50% 14891 1 25% 19880 1 25% Any help? -B ... 15 Dec 2009 15:37

SUMIF date criteria
Can anyone help with a Date range criteria in a SUMIF statement. I'm trying to add up Values in line 4 between 2 dates a b c d e f 1 start 11/11 2 end 13/11 3 dates 10/11 11/11 12/11 13/11 14/11 4 value 2 3 4 ... 19 Dec 2009 07:18

Pivot Tables - get a total different than the summarize field sett
I have a table with region, leaders (rows), points per leader (value), and date (column). I want to get the average number of points per region per day. If I summarize the data using sum, I get the total number of points, not the average. If I summarize the data using average, I get the average number of ... 16 Dec 2009 00:27

If or conditional formatting?
Hi Folks Can some one please help me on a formula? I've been messing with it but can't quite get there. I have two coloumns with dates or blanks and I need a formula to bring back the status of the data A B Status date Blank 1p payable date date ... 16 Dec 2009 06:53

BIN2DEC conversion for large binary numbers
Hello All, I need your help, i want to convert large binary numbers using excel but whenever i use the BIN2DEC function the result is negative which is not correct. Ex. BIN2DEC(1100110110) the result is -202 but if i use the calculator the result is 822 which is the correct value Any ideas? what shall i do ... 21 Dec 2009 22:28

How do I prevent duplicate entry of a sku in a data table?
I want to keep folks from entering the same sku into a table (i.e. like data validation does for other parameters). ... 15 Dec 2009 10:04

Worksheet several pages, Want name to show up on each page
Ok I am creating a worksheet that is several pages long, on each page it has name and other information, How do i set up my sheet so that I only have to enter this information once? ... 15 Dec 2009 16:45