I posted another question not to long ago that I was resolved, thanks to who replied, however, now I've run into another problem. I am entering data on a day...

If G3 is a date and F3 is equal to IF(G3TODAY()-2,"OPEN",IF(G3TODAY()-3,"PAST DUE")) How do I return "n/a" to F3 if G3 is left blank?

I am going to have a few of these type of questions, I think, unless I can plough through this myself. The first formula needs to built like this: In C10...

I cannot seem to find an answer, so I am posting he A B C D E F G H 1 1 5 3 4 2 2 1 ...

I am trying to make the following functionality: Two cells: 1. cell A1 which in it I will write a price without VAT. 2. cell A2 which in it I will write a...

Hi- I think this must be doable, but can not quite "get it". I want to group a sheet by the first column - and be able to expand it to see the detail when...

I have a worksheet that has cells that work differently in one cell if I edit the number (example 21000) in the field to be divided by 7 and multiplied by 5,...

Running Windows XP SP2 and Office 2003, Tab key in Excel has started to jump multiple cells to right whenever I use it to navigate (instead of to the...

I am trying to create a sheet with no code so it is easily maintained. I need to put in some conditinal formatting but can't get my conditions to work...

I'm having issues counting cells with a value of 0. The cells that I'm counting are being filled by another function, but will always be a number. When...

I want to highlight the subtotal rows with gray fill color so they stand out. Can this be done without "pasting" the format from one row to the rest

Hello, I am trying to create an Excel 2003 spreadsheet that will calculate compensatory time. The colums that I have are Earned time (column E) Used time...

When trying to change the font or text size on the home menu in excel it throws me out of excel. This also happens in word when trying to change font. ...

How do I record the date when a specific cell reaches a specific value? ie: Cell "A1" increases in value based on user input. Starts at zero on day one and...

Hello everyone. When added, this code inputs changed values in a range ("g5:g29") to specified ("g31") cell: Private Sub Worksheet_Change(ByVal Target As...

my link formula in summary workbook (destination workbook) is showing error when source workbooks are closed

How can I transpose nXm matrix to mXn Matrix. ie) Want to convert nXm Matrix 2 mXn matrix.

What function would extact the name: 84DTCC 2008_05 out of this. G:\CorporateAcct\SMR\Special\Support\84DTCC 2008_05.pdf Note that the directory and...

I have a list of thousands of records. I need to identify duplicates. There can be more than one duplicate. I am using this function...

I'm a college instructor and would REALLY like to find a way to automatically fill the dates for MWF classes or for T-Th classes. So far all I can get excel...