My linked cells in my main workbook is missing text from the supporting workbooks and I can't figure out why. The formulas are correct but the text cuts off...

When I click on the comma style icon the formats change to dollar sign. I am using a spreadsheet someone else created. How can I make the comma icon work?

I have multiple columns of prices and I want to use one cell, the header cell, to populate all the cells in my price sheet column once I choose the header...

We are attempting to perform a random sort (re-ordering) of employee assignments where a limited number of employees may not be able to perform certain...

In Excel, what do the dollar signs mean in $A$

Hi all, This is driving me crazy. I am trying to make up this formula =IF(E2= 1 and G2 = 20.72 or less its "ok". If over 20.72 subtract G2 from 20.72 and...

On numerous occasions we have used the preset conditional format for highlighting duplicate or unique values. However, we now have come across the need to...

I have what I think is a simple spreadsheet, about 60 columns and 30 lines, in each of 3 tabs. My second and third tabs are just where I dump exported data...

If my database has the ending date of vendor contracts how can I use the timing function with conditional format to automatically calculate to show upcoming...

Am using Excel to calculate a pace-per-mile for runners, starting with "miles per hour". 7 mph is an eight minute and 34 second "pace per mile". I start...

I got one excel book and I was very intriegued by use of sumprod function =+SUMPRODUCT(--($C$8:$C$109="A");--(D$8:D$1090)) Now I need to use it so I would...

A co-worker has a pivot table where one of the source columns refers to cells that could contain more than 255 characters. The pivot table works, but...

Need help with a formula requiring multiple lookups/matches with 1 result. I have a table listing by columns the following B=Motor kW (up to 5 senarios for...

I have a workbook set up to link to other workbooks but the text is cut off in some cells. Any ideas?

I am attempting to build a running daily score average report based on several categories that either have a numeric or N/A value. How do I omit the N/A...

I have the following formula and I would like to automate it a bit more. I want to be able to have the month automatically pick up from another cell. ...

Sorry if this has already been posted/answered; but I'm not having any luck finding it! What I need to do is calculate the duration of a condition in years...

I am sending out a questionnaire to a number of offices and would like to make it multiple choice and provide tick-boxes or radio buttons. I have been...

I have column headings (and sub-headings) that I want to remain in my pivot table, even though there are no data values for them in my raw data. But when I...

Several columns suddenly try to perform a javascript function when highlited. No overt command was given to do that.