Hello, Is it possible to count a specific Conditional Format? For example: Any missing data in a column range due to certain criteria I highlight the cell in...

I have a range of dated in a column and want to arrange them in assending order. My problem is if that this range of data is linked to another data input sheet...

:confused: I need help. I read and re-read the instructions on this on the help on Excel 2000 and I am very confused. Why do they make it so hard? I just...

Is there any way to have excel read all the parts of a nested if statement before returning a value? My formula is...

Hi all, I'm kinda doing a personal project for myself. I want to create excel worksheet tables for all the necessities in daily life. It will range from...

Hello, Months ago I had origionally changed this option, but for some reason it has defaulted back and I can't remember how I had changed it. How do I change...

Does anyone out there know how to link a cell to a stock quote and automatically update the quote whenever the sheet is opened?

I'm using Office XP and am putting text I typed in tables from Word into an Excel spreadsheet due to the columns expanding way beyond 11x17, Word's maximum...

Ok here's one that's been killing me This version works fine B10 to 40 are numbered 1thru 31 C10 thru 40 represent the days of the month with C3 thru 9...

Is there any way to "tone down" the code that Excel 2002 creates when saving a worksheet as a web page? We converted to Excel 2002 this past year at work and...

Hi, I've got a column with a list of times and want to calculate the number of instances in the list that fall within 12 hours. ie. In the table below C6...

In Windows 98, I could search within "all files" and AUTOLISP files would be included in a search for text content in a folder. But now, in Windows XP pro, it...

When trying to link a worksheet to a Word document, Excel only gives me 10 of the 15 rows in the worksheet. I'm using the insert, object commands in Word. (Or...

I am new to excel and I am trying to learn how to create a scorecard. For example, I want the end user to be able to simply type a "1" in a cell but I want it...

I'm pretty new to this game, so here goes..... If I enter a date in cell A1, say 24/11/03.... I then want B1 to tell me what month that is (i.e...

I have a sheet with inventory, col (A) material Col (B) description and Col (C) Part Number. I also have a sheet that does a Bill Of Materials. It gives...

Hi I wrote a vba function that should return data to the excel spreadsheet after querying the Oracle database. I have installed and created a Microsoft ODBC...

I am unable to open MS Excel 97 files - I am prompted with the message "Cannot find the file.... (or one of its components). Make sure the path and filename...

Hi, I'm just trying to create a short pulldown list in a spreadsheet. Instead of having to retype repetitve selections for this spreadsheet that gets used a...

Hi guys Is there a shortcut of any sort to convert a relative value to absolute without having to individually edit the cell. Many moons ago I used to be...