Hello, I would like to count missing data in a Column range due to the criteria in another column range. The problem I have is that the "Birth Date"...

JUST TRYING TO GET A CELL TO CONVERT "0830" (WHEN TYPED IN TO IT ) TO SHOW 08:30 IN THE CELL. OR "1400" TO SHOW 02:00 pm OR 14:00 - JUST TRYING TO MAKE THE...

Hi there, Thank you in advance for any help. I have a worksheet with the top 9 rows hidden. I can't seem to get them to unhide. I've checked the help file...

Hello All, Could someone help me with a formula for winning percentages? Example: Cell A 10 (Wins) Cell B 4 (Losses)

Hello all, I wrote a macro which have to delete some rows in a sheet. The sheet contains many sum formulas. When I start the macro, it work very well but after...

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...

Hi There's a brilliant spreadsheet table that does all the calculations for the games that are currently being played at Euro 2004 but none of the formulas or...

I need to do a separate worksheet for each State, which I can do, but then within each State worksheet, have a separate worksheet for each month. And be able...

Excel 2002 WinXP Brand new to excel I put together a chart that has my blood pressure measurements How do you average the results? How do you add all the...

.... due to formatting changes or something my the contol+end takes you to the very last possible cell available. How can I reset Contol+End to take me to...

I USE A FORM FROM 95 THAT IS USED AS A PURCHASE ORDER FORM BUT IT IS NOT WORKING CORRECTLY THE PO # IS TO FIND THE LIST OF NUMBERS ON THE SERVER. IT SEEM AS IF...

I want to format a row based on the value of one of the cells in the row. Basically, I want to set the color of the row to green if a particular cell in the...

I'll try to be specific - I have a situation at work whereby I need to enter the start of a postcode/zip code - and it returns which field worker covers...

I will try not to confuse anyone but here goes I am working on Excel doing spreadsheets to keep track of peoples pay. I am using 1 document. with multiple...

I HAVE A SPREADSHEET THAT HAS SEVERAL ENTRIES THAT ARE THE SAME EX COLUMN 1 IS TELEPHONE NUMBERS COLUMN 5 TELLS ME IF ITS A B( BUSINESS) H(HOME) C(CELL) I...

all of a sudden after 10 years my xls files from excel 97 are opening full screen instead of in a smaller box WHA HAPPEN I must have hit something to cause...

I need to make a separate worksheet for each State, which I can do, but within each one of the State worksheets I need a separate worksheet for each month. So...

Hi, Does anybody have, or are smart enough to write, an excel macro that will produce random numbers WITHOUT duplicates. I can't see to get my head...

I need to have Excel return the price of an item when I enter it. I work with lists and I frequently type in an item and then I manually enter a price for the...

I am new to Excel 2000 and attempted to save an Excel Document as Web Page that can be changed interactively. However, when I change the content in that...