Hello I am trying to build a formula to automatically determine an employees rate of pay for any given shift, which is determined by the starting time of the...

I am currently working in Excel with a lot of paths like: T:\Program Files\Common Files\InstallShield\Engine\6 \Intel 32\ I need to find a way to determine...

I do not find the microsoft excel help concerning the offset function very helpful. Can anyone help me with using the function to reselect blocks of data to...

"Ben.c" wrote in message ... Hi, I would like to do a countif...

Hi all, I'm new to this forum. I am trying to create a Excel sheet. In that, I would like to add a colum the first one, which will automatically get filled...

"rajk" wrote in message ... Hi, I have a situation where I have three columns in...

I expect this is really obvious, but I cannot find the answer. I have a Excel file with a lot (30+) of worksheets in it. I want to produce a list of all the...

Hello Excel experts, here is my need. I have set up a spread sheet with validation lists in one cell on each row. The user can choose "funded", "in process"...

You need conditional formatting. Select all of the dates. Goto menu FormatConditional Formatting Change Condition 1 to Formula Is Add a formula of...

I created a spreadsheet with the following a1 - Sales price b1 - Commision paid b2 - entered the following...

Hello, I am trying to apply different format (e.g. colour, font) to all the cells that contain certain text. For example, I would like all the cells containing...

I am using the VLOOKUP function to compare values from one table to values in another table. I inserted the VLOOKUP function into one cell and it works fine. ...

Hi there, I have created 1 workbook and have copied it 3 times (one copy for each employee that will be using it). I have also made a master copy where I would...

I need to do a VLOOKUP where if there is no match found I do not want the value to be #N/A. How can I accomplish this? T.I.A. Ed

I have a column in a worksheet called "office" and one called "address". a list of each office address is in another sheet like so: Office ...

Does anyone know if Excel has a function/formula that can in any way take information from a summary sheet within a workbook (this sheet is more like a running...

I have a price list formula that calculates from basic fixed amounts in certain columns and rows. Is there anyway to change all the fixed amounts at once. I...

Hello, I have the function below, which returns the corresponding label to a value that is extracted from a table on a different sheet in the same...

I have to combo list with dates , to choose date1 and date2, wich are taken from column A , so from A1 to A... we have dates (dynamic range) In C1:I have a the...

Hello, I am using a List in a data Valadation style drop down menu which gives the user a choice between 14 titles in the list. What I would like to do, is in...