I've an Excel Spreadsheet with 6 columns, 1 column which has a question, 4 of them I add figures to and these are totalled etc, and then there is 1 column...

i have excel file in which data is updating automatically by some another software . now I want to fetch data from file in every 100 miliseconds and store in...

I am trying to create an average of a range of cells - B2:F2000 - but only if Column CJ is 1. I am also trying to inset this equation to a different...

I am using Excel 2003 and I was working on an Excel workbook yesterday (which is over a network). Before finishing for the day, I closed the file, closed...

I have a spreadsheet with hundreds of rows and six columns (7 with total). Once completed I need to insert a row for each column with data in. Each row is a...

Hello I have WinXP running Excel 2007 (latest update from windows update) From time to time excel becomes covered in a light blue wash and it is impossible...

OE can no longer find microsoft.public.excel. It no longer appears among my subscribed newsgroups. I had an access problem earlier, so I might have...

Hello Experts I looking for a formula that will count the number of instances of "A" in column A AND "PAI" in column B. Eg. A PAI A RENU A PAI

Hi: I made an improvement to this code whereas it will cut in an * if any IP section is missing. It results like...

How do I take phone numbers from one column and then match them to another column so i can see how many numbers are the same?

How do i set my calculator to round up, because it is not rounding up decimal place values. I have Qoutient (31200,102) the answer gives 305 but it should...

I am a part of a 12 week biggest loser contest. I am trying to create a spread sheet that will capture the percentage of weight lost each week by just...

I have a table with a list of names and each name has an object associated with it. Is it possible to perform a look up by selecting a name that will return...

I have opened an Excel file from email & saved after making changes (without indicating the location). Where can I find the file now?

Running Excel 2007 in compatibility, sicne I tend to share stuff save files as 2003 .xls. I have a vanilla workwheet, nothing fancey, no functions, just...

Hi, I have a long list of numbers ie 1.2003 to 7.2007 that are not in order how can I sort them so I get them in month and year order. When I do a sort know...

Hi I created an Access database which exports data to Excel. I would like assistance in creating the required code which would allow me to sum some...

Hello I received a workbook and all the dates are formattted as text and look like this 090323(means Mar 23 09) . How do I format this as a date to read...

I'm finding that I'm getting a compatibility error within one workbook when I run the compatibility checker. I have found that it depends on which...

I have a dynamic chart, thus every month when I add new data, the chart automatically updates. The problem I have is the Axis Range that Excel automatically...