I want to use/create a function whereby if a value is equal to one number the data i enter will go into one of a series of cells example - if the value is 123...

I want to be able to get a vale from another Excel file where the value of "E3" will change depending on the day of the month. Below was what I tried, but it...

I'm trying to put together a set of worksheets for work that show up who's on a tea break at a given time.. The project has 3 tabs at the bottom to choose...

I need a function guys! I need to sum the numbers in column H (H2:H300) but only those numbers in the rows where a specific value exists in column B . I need...

I'm trying to work something out and I am trying to find out if something is possible... Basically I do the losses and gains at work for various stocks - I...

In excel 2000 I'm trying calculate a total time in minutes. I have two cells: one cell is the begin time and the other is the end time. Time is input as a 24...

In a worksheet with multiple columns of dates, how can I identify any duplicate dates , if any, among columns. many thanks -- db

I recently switched from 2003 to 2007 and cannot seem to find the function to create scroll bars, check boxes, etc. in Excel 2007. I'm sure the feature must...

how do I transfer a balance sheet to a worksheet in Excel?

I used check marks in a spreadsheet. Some of the cells have a pattern (yellow) to as an identifier. I need to be able to count the number of cells that have...

Is there a way to use the "value" of a name in a drop-down list to reference a sheet tab name in a formula? A1 has a drop down list. When a name (Bob's...

Hello, I am working with order forms for different types of equipment, each having its own worksheet. After selecting the appropriate sheet, I then want the...

.. What I want to do is attach a formatting option to a toolbar button. I can generate the formatting and record the macro to do it. I then want to attach the...

Is there a way to have the result of a if function format the text in a cell? As an example, fi the test is true, the function will turn the text red.

I know there is a way to select arrays on different sheets one array at a time. Is there is a way to select arrays (located in the exact same cell range) on...

I have worksheet that uses the =today() fuction as contents. The spredsheet is saved as a template opened data entered then saved as a file. Several of these...

I used the z test in data analysis to test whether the mean of two sets of scores were statistically significant. What I do not understand is how to interpret...

Hi This might be a very simple question to most of you, but I am a novice user. If A1 has date in the format 04-Jan-06, then how do I have B1 display only...

Hi I need help with this please. I have an excel sheet which gets data pasted onto it, on the basis of top 5 ranks for that day. Like This: A B ...

I have an excel sheet with the month and year in the A row..Like Jan-06 Feb-06 Mar-06 Apr-06 How do i insert a formula in B row, to display the number of...