Excel 2007 - I am having a problem where I have multiple cells with paragraphs of data in them. When I am working in the cell it shows the last line of data...

I have a spreadsheet containing Training Information. A simplified version is laid out below :- The rows contain the Staff Name and Service Area and the and...

Hi, I looking for a script that will do this: Inputdata: 4702168703 Outputdata: 1947 Function: I will import data with 10 digits, I will erase all digits...

Dear Experts, I have a situation where I import tabular data from an engineering drawing in which some data may be of the form 012. However, upon typing...

I am trying to fix some pie charts I've got, but can't find a way. The borders have lots of points and I need to make them smooth. Some websites suggest to...

pLEASE GIVE ME TIPS TO OPEN A WRITE or PROTECTED SHEET. THIS TYPE OF FILE I CAN NOT OPEN.

Hi its me Atif i have office 2003 installed in my pc . issue is this due to come virus or any perob my all Excel.xsl files not beeing opne its show mention...

I attempt to copy a worksheet from one excel file to another, I have both open, highlight the area in worksheet #1, hit copy, it appears on the clipboard, I...

Does anyone have any suggestions on how to determine the value from a list? Under column A, there is a list of date, and under column B, there is a list of...

Greatings from the SF Bay Area. I'm lost on a particular problem. I have patients that are in and out of different departments like ED and Clinics. I'd...

I am not doing this properly please help! I have a table shownig days on market days Number Sold Avg Price 1-100 ? ...

I entered '1234 (note the apostrophe) into A1 and the formula =(A1=2000) into A2. I was surprised that A2 results in TRUE. Why is that? If I enter the...

I need to compare data in two collumns and filter out the new data. Any formulas for that? In other words I have a collumn with names from last year and a...

I have a macro that works perfectly in earlier versions, but since upgrading I can't seem to figure out the settings. When I attempt to run the macro, I get...

Hello, I set up a pivot table based on data in a web query. I added a few helper columns to the right of the web query data that apply formulas to data from...

Hello- I want to populate a table in sheet 1 by matching a cell value to a table in another worksheet and returning the value related to the cell....

Excel 2003 I made a beautiful spreadsheet doing some calculations for real estate finance and went to protect it so users can not inadvertently alter it....

Hi - I'm stuck I have a set of data like this A M J J A S O N D Contractor Fault 1 1 2 3 4 ...

Hi, This could be a real challenge. Is there a way to build a calendar (1 per sheet) in Exce1 2003 and populate it by referencing a list of dates and...

I'm trying different tricks with COUNTIF but nothing seems to work. I'm trying to get Excel to give me a count of cells that contain data, except those that...