I have an excel worksheet that I will publish onto the internet that contains various information relating to an individual. I want users to be able to click...

Trying to work out the annual cost of machinery purchase but having difficulty getting a function which seems to incorporate all that needs to be considered....

I have a spreadsheet with a pivottable in it with data from a different sheet inside the same spreadsheet. For some reason, it is combining/separating data...

I have conditional formating & color in a cell, but I want to color the entire row of conditional formating cell. Is there any option to do it ?

Hi, Is it possible to create a comment for a cell with autoshapes instead of rectangle shape. Regards, Vinod

I have a Visual Studio Team System table of work items that is linked to my Team Server and refreshed from time to time with the latest details in Excel...

If I write anything in a cell, that should be capital letter automatically. how can I do it. Suggest me.

In a column, I use conditional formatting, the formula is: =COUNTIF(R2C4:R22C4;R2C4)1. When dragging this formula over some 10.000 rows, I'd like the...

I've searched and I can't find what I am looking for; thanks in advance for any help given. Table is as follows: Column A Column B ...

Dear all, I have got a worksheet with formulae in some cells, please tell how to display formulae in these cells instead of showing the...

Does excel have a "best of" function - i.e. summing the best 3 out of 5 for example?

I am trying to determine if what I have is an Excel bug or is there another way around the formula. I am trying to have VLOOKUP collect some data from...

I have a table that has 8457 rows, within the table there are 12 models, and within each model there are 5 phases for development. What I'm trying to do is...

The following formula gives the error of "Cannot open the specified file". =HYPERLINK(H1,"X") When cell H1 contains a string, if the cell is empty nothing...

I would like a template or someone to tell me how to set up the formulas that would figure out the remaining loan balance after each payment. It's owner...

I am trying to build a worksheet with 50 tabs and a summary page. Each contain lists of data. I want the summary page to look up and match the data on each...

Need to add Qual Hardware+No Charge+DAT Hardware+Outside Lab+Purchased Items for all projects month wise. All Projects are of same format (i.e they are at...

NEED TO ADD THE FOLLOWING. 3 ROWS SEPERATE THEM & ANY NUMBER OF ROWS CAN BE ADDED: 1 1 1 1 1 1 3 ROWS BLANK

I have like 300 columns with 50 values in each and I want to find duplicates accross these groups - e.g. number 23,5366 appears in group no. 23, in group no....

Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I tried it, but it just read 10-5. So I then tried clicking Enter, but it then...