I need the remainder results of a multiplication formula. The Function INT should provide this results -- Excel Function Help for INT provide the formula...

I am using a spreadsheet for direct mail and am having problems with the zipcode field. The vendor requires that the file be in a .csv file format. The zip...

Hi guys, Re-table below in cols A to C where its required to calculate the "Diff (mins)" in col C (Col C = Time B - Time A) Times are in text in cols A & B...

Hello, I have a 2 column worksheet, & am attempting to get a count of how many rows contain certain text strings. ...

Hi All, I have a problem with an excel funtion that i created, i have a series of defined named range pointing to various cells, however, i cannot seem to...

I would like to know if I can return a range of cells (up to 30 columns to the right of the lookup) when using vertical lookup forula?????

When I type a date in a column formatted for dates, and then hit "enter" it always shows "######". If I put the cursor over the cell, the date will show, but...

THEIS IS MY PROBLEM: vehicle no start km end km tyre location x123 56 65 4 x123 65 75 ...

Hi , is it possible to lock and unlock with protection passwords (all using same password) multiple sheets, in a workbook by using just one command or do they...

I have 4 worksheets that need to be consolidate into one to form a master listing, there are known duplicates between worksheets - total ~30000 records and 30...

I'm attempting to calculate the maximum value in a range of cells in 60-80 closed workbooks. I have this in cell A1 'Y:\Folder1\Folder2Title'!$A$1:$A$20 I...

How do I find unique values from column without using FILTER Option of Excel?

I'm trying to search a large workbook for specific work order numbers, can I do this or do I have to search each individual sheet?

is there any way to populate multiple data from different workbooks at once using any function? EX: workbook 1 col1 col2 a 1 b 2 c 3 d 4 e 5 f 6

Hello everyone: I am learning to highlight duplicates in dynamic range. The problem I have is that the highlighting is not been applied consistently to the...

Are there any free addins or macros for excel that will do a lowess fit?

How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend days??

excel 2003 - office professional. I have data for water temperature from two reservoirs taken over 5 years. I want to match the water temperatures from the two...

need to count # of times x appears in column and have a value of 1.. then need to be able to have sum of "x's" in cell range C4:c156

I need to freeze the second column and the first row. Excel only allows me to freeze either the first column or the first row. Not both at the same time and...