I have a worksheet that contains 2 columns - a list of bar codes in one
column and the department name in the second column.  I then have another
worksheet with 2 columns - a list of bar codes and the cost price relating to
each bar code.  The list of bar codes are the same in ...

I'm trying to do a countif function where my criteria is a date range, like
between 8/1/2007 and 8/31/2007.
Thanks for your help!

I have a worksheet to calculate wages.  I enter the start time, finish time
and the pay rate.  I need to get the wages payable which is a simple
multiplication of hours and the pay rate.  But when I do that calculation, I
am getting the value based on time value x the pay rate, ...

Excel 2007. Working with a dynamic chart, using named ranges. A couple of
challenges for someone clever...
1. The first formula works as a data series, the second will not. When I
type or paste the second into the forumla bar for the chart, it will not let

I keep getting an error with a formula that I am working with.  When I build
the formula through the Function Wizard I can see the result but when I click
on OK I get a Value Error.
Here is the formula

After two hours of figuring out how to get one of those cute option
buttons...I don't know how to add a value to the buttons.  Example I need one
button to be worth 4 and then I need them to add all up at the end.  Most of
the butttons are worth the same thing so I dont know if I ...

Is there a function in excel that removes special characters (ie: # \ @) from
a cell? Would appreciate prompt reply.
Thanks,

Hi,
Can any one let me know how to calculate compound interest in excel using
formula for function.
Thanks in Advance

I have a worksheet that gets it's data from an outside program. When I
refresh the spreadsheet, if a new product is added, it gets inserted
alphabetically, moving all of the other cells (rows) down. My worksheets that
reference the cells now have the wrong data as the information ...

is there a way to arrange worksheets inside a workbook in alphabetical order?

I merged the cells horizontly and vertically, How to take the print out so
that the appear with data sheet? not separate

What would be the proper syntax to sume the largest number from the same
range of cells on different sheets?  I've tried a couple different ways, none
have worked yet.  Here's the current version, but I'm not sure what part of
it is wrong.

I have a table with two columns:
Col_1       Col_2
XXX-YYY   123
XXX-YYY   120

I did a bit of a search on this but when using VBA and having the
following equation the Cos function returns a value of 1 rather than
the correct -1.  What am i doing wrong?
temp=cos(pi)

I've been using the proper function this morning and its not working for
some reason.
Cell B3 contains the word: MISS
I want cell C3 to contain the word: Miss