Can anyone tell me how to use the the output from the fast fourier analysis tools?

Hi - I'm interested in clearing cell's number using a 'button', will macro program work? I'm not sure how to begin. For Example: A ...

I've created a VLOOKUP using the function wizard. After entering the 4 parameters the wizard box displays the function result. When I click ok and return...

I would like to hide/unhide columns using the column width (equal to "0"). I would like to do this as a result of the contents of a cell. For instance, if...

Dear all, Office 2003, Windows XP Pro SP3 I have a column of dates in the following form 13.11.2009 (i.e. dd/mm/yyyy) where the cells' format are 'General'....

A client's spreadsheet shows a sum function which calculates individual cells for instance =sum(B2,B4,B6,B8) then saves and closes the workbook. When she...

I have numerous occasions where functions (like countif) need to report on cells containing text strings or starts with text strings. In various database...

Hi! I'm getting that "Enable Macros?" message when I open a workbook even though I've taken the usual steps to remove any macros in the workbook. I've gone...

Is there a way to only add cells in a column that have a certain colored font? I looked at the link at http://www.cpearson.com/excel/colors.htm but I...

I have dates in 1 column and total amount (income) in another column. I need the total amounts say from 1 Jan 10 to 8 Jan 10. Logically: I want the sum total...

I have a worksheet that records sales details from 3 separate tills and calculates total sales for the day etc. One of the figures from each till gets...

I need to count a total for a series of text vales and multiply that by a number that appears in a a corresponding cell in an array of text. The multiplying...

Dear All in below eg I want to extract only NV,MN ,MF and so on which are user name, LKOC is remaining for all, other thing are differed. LKOC_NV_SALARY...

Hi, Is there a function to show the actual network path of the mapped drive? Unmapping is not an option as it is mapped by a number of users (all are...

I have this code so that when I write a name in column A, the date and time appears both in column B. All I want is that the date appears in column B and the...

I am trying to create a sum if formula for multiple columns that cross over each other where the criteria is in the first column and the values are in the...

want to lookup up the date value entered in cells C15 through C22 Lookup table = $C $6 through $D $11 and return value in column 2 Problem - dates in C15...

Hello, I have been tasked with trying to do the following Column A - Date column B -Date A will always be earlier than B columns C-N will be labeled months...

I am trying to send my reply for one of the OP query and I have sent reply more than 4 times and I didn't get any error notifications also. After pressing...

I have 3 columns of 24 cells headed 'gold' 'silver' and 'bronze'. each of the 24 cells could have 1 of 5 answers depending on other calculations elsewhere on...