I have two cells contain date A1 : 39508 (after formated = march 08) and B1:39539 (after Formated = April 08) How do i combine this Two cells to C1 if I need...

i need to enter 2 paramters to find a product. para.1 para.2 answer 2" pipe $2 pipe is a vertical lookup & 2" is horizontal....

I have a spreadsheet where I need to calculate the time off that people have acquired throughout the pay period. People ET or Earn Time at a set rate at the...

hi all, xp pro, office 2003 pro, i don't know whether i wanted is possible. i have tried to search this group as well as the general 'google' approach but...

I have a sheet where I have 149 columns each containing 33 data items. Is there a way to sum the highest 8 scores in each column?

In Excel 2003 can I change a group of cells (e.g. a column) so their results all become negative or do I have to change each cell individually?

Hello! How to appy a thousand new row names to formulas which use corresponding single cells in the rows? or How to replace thousands of single cell...

Can you calculate whether a time is between two other times to show early, day or late shifts for example?

Hello Is there a formula that can be used to return a "true" or "out of hours" value if the date/ time of a particulr cell is outside of (my) business hours...

can the count if questions cont rows that have two different inputs in different columns? I need to count rows in which any of the columns in that row...

How do I count how many times a date appears in a range of cells? I would also like to count the number of times a range of dates appear in a range of cells.

Hello. I need to know if there's a way to return the average of the last 3 cells in a row, no matter how many times values are added to the row. Thanks.

I have list with 5 columns. I am trying to identify duplicates in rows and columns can this be done in Excel? or How should I go about this? For...

i need to count the sum of values in column A if column B "sent" ... sent is text written into the cell thanks in advance.

I want to enter data into a cell, move the cursor to another cell and at the same time automatically delete the data that was entered. Is there a function fro...

I have a Certificate of Deposit that automatically transfers the interest to another account. I'd like to create a worksheet that would tell me how much...

Need help with formula to round (always round up) pricing to the next $9.99.

Hi, I have shared an exel file, which has a password (share and protect & sheet protect), and is on a network. When you try to modify the data the box comes...

Using Excel 2003 My PivotTable is set up as follows: RESOURCE NAME TASK NAME HOURS WORKED name1 ...

=COUNTIF(B$3:B3,B3) How do I make this, =COUNTIF(B$3:B3,B3) but not if C3 is "Inbound"? Thank you.