i want to know how to calculate the following things A B C D 12345 20GP ALMAR MTY 67892 40GP JV ...

id like to color saturdays and sundays with different color then my workdays. Is it possible to do this using conditional format? And how?

Hi all If there is a figure entered in D10 it prompts, in B11 a hyperlink to become active with the the following =IF(SUM(C10:E10)0,HYPERLINK("C:\Program...

Hi All, I have a worksheet with a cell on it which is formatted as a %. If I protect the sheet and single click the cell to enter a new value, I type 5 and...

Hello. What I have is a spreadsheet and when you open the workbook Cell H2 is empty and the user selects either "System" or "Detail" from a dropdown list...

I am trying to sum the data in the Data table as Regions (see Results table), using the Lookup table to find the region (Lookup Table), without the need to...

I am copy and pasting an htm form to an excel file. All works well except one field. On the htm it is a fraction - 4/4 , 3/2 etc. It converts to date of...

A B C 1 13 21 2 23 13 3 13 4 4 32 5 14 15 Please help with this formula. Example: B2 & C2 both have numbers and also Columns B5 & C5. Since both of...

Hi, I have a user form which contains text boxes into which I type the date in format dd/mm/yy. However when I click on the enter button and the data is...

A B C 1 12 14 2 15 14 3 12 15 4 12 15 14 This is the data I have to work with. I need help with getting a formula to do the following: 1) Take Column A...

Hello, Is there a way to sum columns in a Pivot Table (between the additional columns of data I add)? Without having to use multiple pivot tables? Thanks

Hi guys, I am currently using the below formula that returns certain data from a report ( multiple rows and columns ) and it's based on a product name. What...

I have about 600 email addressesn Excel database. I wish to send and emial to all these emails. I know you can copy and paste the email addresses to the...

Have received a long list of names and email addresses in a CSV file. I would like to use the email addresses directly from the spreadsheet, by clicking on...

When I select nonadjacent cells in Excel the color of the selected cells are so similar to all other cells that they disappear. I've tried everything. Don

Thank youl. I was trying to round down to the next whole number within a formula. I searched rounding and found your answer to a post from someone else...

When I open a new Excel 2007 worksheet, it has only 65,536 rows and 256 columns. The title of the worksheet says "(Compatability Mode). How do I open a true...

How can I sum several cells and display the result in a textbox -- Tdp

Microsoft Word contains the command of CHANGE CASE which is very useful, but Microsoft Excel does not contain this command due to which its too much...

How do I use sumproduct to return December data from a database if the range a1:a1000 is formatted mm/dd/yyyy? =sumproduct ((a2:a1000="december")*(b1:b1000))