I am trying to write a spread sheet that will convert say 9-5 or 2-10, convert these to hours and add them up at the end of the row. Repeat the same for other...

Recently I received assistance regarding a referencing problem I was experiencing. (See 8/30/04 8:38am) Another problem has surfaced. I want to take ages...

Is there a function or a code I can create in Excel where I can create hours into days with hours and minutes. For example I have 10.66 as hours..I want to...

I HAVE A ROW WITH ADDRESSES IN FORMAT A B C D BUT I WANT TO TRANSPOSE TO LOOK LKE THIS A B C D

I need to count the number of items in a column if some conditions are met in other columns: Col1 Col2 Col3 Item1 Yes ...

I need to test a cell value to determine if is negative or positive. If negative, the value gets subtracted from partA and added to partB. If positive, it...

I would like to collect some data's from different excel files in an separate worksheet. All the files have one common cell (project no.) Based on this may I...

I have a simple VLOOKUP(A2,Source.xls!production,5,FALSE) in the 'Original' sheet and everything is fine except some values. It gives #N/A. But, it's there...

I'm using a SUMIF FORMULA..but haveing problems cause of the date. In one tab I have amounts for each date that is formatted May 30, 2001. For example that...

Could I get some assistance with a criteria for (i think, COUNTIF)? Using the below as an example. what would be formula be to say: =number of rows that have...

I have a column with alpha numeric data. How can I break this one column into separate columns like the following: 3S1W1 ---- 3S 1W 1 3S1W2CD -- 3S 1W 2 ...

I have a sheet which lists customer complaints. Each row is a different complaint and has a cell for "Closed date". Is it possible to have the values from the...

Hi I would like to add a drop down list for the all the names of CDs that i have. Does anyone know how to do this? Thanks in advance.

How do I make a certain cell coloured within an if statement i.e. if L4=3 if true: Green if false: Red the question is how do I make the cell become green...

A while back, I created a function =M(,). I want to find the formula of the function because I forgot what it does. Thanks. Alex Psychometric Research

2/15/2004 (this is the search date entry.) lets say A1 This is the Months backed off from the above entry date month, 12 total. I need this to be automatic...

I want to add '0 to every line of a list in a column. I think there might be a easy way to do it. For example: row B 34 35 36 37

How could I convert the column with the phone numbers such as (630) 469-5600 to 630-469-5600. If it's the phone with an extension such as (630) 539-3100 223 I...

I have a column with text cells. I want to find MIN for numbers inside these text cells that are before " /" or "/". I'm getting the numbers by using the...