I want assign importance to each list option when selected by colour. Is
there anyway to do this?
Thanks

Hi - I'm a student teacher and as part of my Maths course I need to do
a project using Excel to model something - WHAT???? I have know idea
what things I can model using Excel I'm pretty new to Exel but I am PC
literate so pick things up easy...if you could recommend any books that

I'm trying to figure out someone else's workbook. This is the formula that
produces the correct contents of the cell in data!V4  on a different
worksheet.
=MATCH(9.99999999999999E+307,'Data'!A7:BA7)-1

Excel 2003, SR 1
I have a timesheet database, showing employee's name (Col C), clockin, clock
out on each line, with hours worked (Column L) in Decimal format and Subtotal
(Column M).    

Okay, let me give you some background info on this project I'm working on.
I have 2 spreadsheets that I am working with.  Spreadsheet A is a 12 month
report, a colum for each month.  The left side column holds part numbers that
are sorted by the different areas that mfg them and ...

i am attempting to average a range of cells, in which each cell value cannot
be above a certain quantity. if a cell value is above the set quantity, i
want for excel to calculate the average, excluding the cell reference that
contains the value above the set qunatity. in words, ...

I have 13 worksheets, same workbook and same column titles.  Looking to
combine all 13 worksheets into 1 master worksheet.  Anyone know how?

My brain hurts from trying to work this one out, I'm no wizard like
most of you on here.
Anyway here's my problem...... hope someone can help.
scheduledreleasedate    14/03/07        21/03/07

My brain hurts from trying to work this one out, I'm no wizard like
most of you on here.
Anyway here's my problem...... hope someone can help.
scheduledreleasedate    14/03/07    21/03/07    28/03/07    04/04/07

I have a cel that does some calculation and I don't want the value to go
below zero.  The formula in cell A1 is =IF(B1=0, A2-B2,A3-B3) so if either A2
or A3 is less in value then B2 or B3 then the result of the formula is a
negative number. How can I do it so the value will not ...

I know I'm being "dense" but have been fighting with the correct syntax to
add an ISERROR forumla to my VLookup. Can someone please give me the correct
formula?
My VLookup is: =VLOOKUP(E2,County!A:B,2) and I would like to add the

Can you set a forced format within forms?  (i.e. state = 2 alpha, capital)
When someone enters ca it will change to CA or title case verses caps for
data entry?

Hi, I have a worksheet for counting working hours. In one coloumn I have
"Work" og "Freetime". One for each day on the calender. can I sum the numbers
of "Work" and Freetime"? If it is Work...I have to add 8 hours of work to my
time,, but if it is "Free" I have to (-) 8 hours. It ...

I want to do more than three conditional formats....the condition is if the
word 'deliver' exists the color should be green....if the word 'tank set'
exists the color should be off white....I have about twenty words with twenty
different colors...any suggestions. Thanks Chris

I am looking for a formula that will calculate a accrued late fee with two
variables “late fee” and “intrest”.The folloing in the logic behind what I’m
trying to do. My goal is to do this with one formula ?  I have been exploring
the financial formulas with absolutely no luck.... ...