I am working on a time sheet with Cell H3 being a sum of actual times
calculated from a range of other start and end time cells. If there is no
start/end times entered the return value in the cell is 0.  I am then
calculating a wage value based on the expected time (H2) vs actual ...

I hope someone can help me with this. I have four cells A1:A4. If all four
cells contain data or are blank then thats okay. But if 1, 2 or 3 cells
contain data then I want a warning that all cells must be blank or contain
data.

My Office Manager has a spreadhsheet containing last names, first names,
addresses, etc. As the spreadsheet gets longer, she worries about accidently
entering identical information (last and first names) without realizing it.
What I'd like to do is the following:

I am trying to create a drop down box and with what ever i select from it put
the price two cells over say backhoe cost is 44.57 hr backhoe trencher blade
will be in the list in a1 and i want it to put the prices in d1 and there
will be diffrent prices for every pice of equipment ...

I'm working with a large dataset, with over 800 variables. I would like to be
able to arrange my columns alphabetically, by variable name. So, let's
pretend I had only three variables, instead of 800: "cars," "boats," and
"animals." These three variable names also serve as my ...

I have 2 date columns. I would like a formula in a 3rd column to tell
me the differance in days of the two date columns

Im trying to work out a time sheet for work and the problem is that i work
with 24 hr clock and shifts can start at any time over that period and finish
around 8 hrs later...
i need one result in the formula to answer the time worked in one day

I have the following formula written into cells AH4:AH3500 and it works
PERFECTLY. If possible, I'd like to use "conditional formatting" in cells
AH4:AH3500 to turn the cell "yellow" when the following flag (form the
formula below) pops up: "Send IDIP 036 to DPHS":

Took me a couple of years to just figure out how to manage cells and
calculations some time ago and have been setting up these for any and all
accounts I have. I have numerous worksheets within one workbook. These are
mainly for financial transactions. Need help in figuring out ...

How can I create a validation or can I, using a column that is located on a
different tab? Thanks

I need to create a ASCII semi-colon or comma delimited file. The text in the
file need to appear as follows:
“4400112453”;”James”;”E”;”Smith”;”111121111”;03/10/1962;7/01/1999;6/30/2003;4;”05404”;1998
I can save the text file with the semicolons or commas as delimiters;

Does anyone know a function to take the number from the first cell above a
gap of cells.  What I've got:  a date column, depth column, elevation column,
change column.  Not every date has a corresponding depth/elevation/change.  
I've got it set up now that the change in elevation ...

I'm trying to find a formula to make a certain cell if it is left blank to be
able to highlight it with a color.  Anyone have any ideas?  Thanks Kimo

I hope I am posting this to the correct discussion group.
When converting a .tsv file to Excel using the Text Import Wizard > Column
Data Format > Step 3, which is "Do not import column (Skip)," is there any
way I can globally exclude columns?  I have 50 columns to exclude, and

I am trying to link data in the 2nd worksheet called Equipment to the 1st
worksheet called Quote.
In the Equipment worksheet I have 3 columns of data that are related.  The
first column is item, the second column description and the third column is