I have a spreadsheet that has rows of employees.  The header row lists Name,
Mon, Tues, etc, through Friday, with TOTAL HOURS WORKED at the end.  Each
row, under day of week listed the employee's work hours (ex: Under Monday I
have 7:36 - they worked 7hrs and 36 minutes).  How do ...

I have 3 conditions defined across 3 columns of data, each with 0's or 1's
depending on partnership status of an account.  If all three conditions /
columns are 0, then it is a company direct account.  I want to consolidate
the date into 1 column (Company Direct, Partnered on ...

when I type 1 it is displayed as 0.01

For some reason my Danish Excel wont recognize "HÆLDNING"? Even copy-paste
from the help file won't help and it is not on the drop down menu when I
write H.
Any clue why?

I have a Formula that gets data from another tab
EXAMPLE:
=' TAB NAME'!$C$16
I want to be able to put a number in a different CELL that will change the

Hi there, I would like to use a function that would look at a number in D1,
check to see if it exist in range A1: A8, if the number does exist then
display the D1 number in the formula cell, else display the number 1.
       If Number exist!

Can someone please help with a formula?
In Column A I have names formatted as SMITH, John.  In Column B I need John
Smith.  Would someone please help with a formula that would switch the names,
get rid of the comma, and change the case to lower case of the last name

I downloaded an excel spreadsheet from a website. Column A:B on the
spreadsheet is a reference for my vlookup formula in another worksheet.
The cell where my formula returns #N/A.
Say Column A5 reflects 2000.01

Is it possible to group individual worksheets under one general tab??? For
example: grouping all of May's worksheets under a specific tab for the month
of May????

Could someone tell me how I might remove data (phone numbers) in a column
and only retain one a duplicated number in the column just once?  Basically
needing to remove duplicates.
Thank you

This is probable very simple and I am just overlooking it. But can some tell
me how to find out if a date range falls between or overlaps another date
range?? Tab 1 contains start and stop vacation dates, tab 2 contains start
and stop blackout dates. I need to list on Tab C2 if ...

I would like to select multiple records from a database matching certain
conditions and then extract the information from the record to print on a
form.  Am using Excel 2003.

Here is the problem in a nutshell:
Column 1     Column 2
58000             100%
7000                50%

I am trying to do a vlookup on Group Names and return a sum of the unique
values only. I have many Group names all over this sheet and much of this is
repeated (It is important for that sheet). However I just need to have a sum
of all unique values.

I am trying to conduct a “what-if” analysis for a fairly simple financial
model. This model is basically one extensive income statement that contains
historical data as well as forward-looking statements. Historical data is
hard-coded while the forecast data is driven by revenue, ...