How do I count the number of records within a date range. eg 1/1/2003,1/5/2003,1/10/2004 Using countif between 1/1/2003 and 31/12/2003 = 2

I have created a report for our company that covers each day of the month - a 31 page workbook. It looks great, but I now need to protect it. I realize that...

The 2 data sets are assumed running in A3 and in B3 down, viz.: In A3 down is: 1, 2, 3, 4 and 5 In B3 down is: 2, 3, 2, 6 and 8. In D3 is a parameter which...

Hey, I have a column filled with text. there are about 100 cells in this column. Those cells each have the name of a single corporation within them. many of...

Hi! How to find repeated data and then merge and centre. My data is from A to M.Range from A1 to M4500 Any Function Or Macro. Thanks Hardeep

I need to flag duplicate names in a spread sheet sorted by Surname, Given Name (separate columns). In other words... IF (the surname and the given name in...

I am not sure how to get my words to go vertically on top on my spreadsheet in excel.

I would like to be able to type the first few letters in a cell that uses a long drop down list and quickly go to the full name in the list without having to...

Hi I run Excel 2000 I have a list of names with each one of them having a hyperlink to an email address. These all work fine. What I would like to do is...

I want to count how often a single value (the dash symbol) occurs in a single cell than rank it. Showing two examples, AUS-IAH/PTY-IAH/AUS is in cell A1...

How can I auto activate of a macro with respect to date

I really need to know how I can print my finished excel spread sheet on the same paper but I need one side with a clients supports and then the other side...

hi, I want to calculated travelling cost depending on the days of travel. I have following data. (0-7)hrs-0$, (8-13)hrs-5$, (14-23)hrs-10$, 24hr-20$. Now...

I have the following: Attended Attended A B C D E F 1...

hey guys can any one help me?(of course it is not a excel question) My drives are not openinin. if i double click on my drives an "open with" window opens. I...

I am new to macros but have worked out how to transfer the results of a calculation to a row on another sheet. When I clear the original data to enter more...

I copied and pasted a calculation from the Help display and when I clicked off of the calculation. It should have calculated but didn't. I am using Excel...

Who got highest mark in class? looking for formul for the spread sheet. OR if there are 4 sections which section got the highest mark and who got the highest...

I am using Microsoft Excel 2003. I need help with the Auto Fill Options. In cell B1, I inserted '1'. In cell B3, I inserted '2'. In cell B3 - I put in...