In columns “A-E� I have information about invoices Column “D� is the invoice number ( invoice number would only be referenced once and will not be...

I have Windows XP 2002, home and small office edition. I need help with a formula that will do the following: 1. If a number (i.e. 12) is entered into a...

I have a data validation dropdown list box in "sheet1" cell $J$1. Depending on what I have selected in that dropdown list I would like it to match or lookup...

Not a lot of error checking:- Assumes data in Col A and values in Col B - Will finish the first time it hits a blank in Col A Sub...

I need to calculate how many seconds are between two times, e.g. 8:08 AM start time and 8:44 AM stop time so I can use the result in a formula. The start and...

I am using VLOOKUP to determine addresses from a master list. However I have found that if the Lookup Value is NOT in the Table Array, I will get incorrect...

HI I'm trying to show a selected cell reference in a popup , rather than the cell content. This is the code : Dim lrow As Long With ActiveSheet ...

How do I get the data labels to stay where I put them in pie charts. I have a series of pie charts set up and update the data they are based on monthly. I...

Hi I have the following data Col-A Col-B 1/10/2009 10:20 0.006 1/10/2009 10:22 0.007 1/10/2009 10:24 ...

Earlier today I was given 2 formulas for a problem I was having. I started with a formula that worked and I wanted to add 2 conditions to it. The formula...

i have 12 columns with data on days and each new day i want to add a new day to the set of 12 columns without adding a 13th one. So the oldest day are...

Hello, Can a conditional formula be written to convert a cell with text and a number to a cellw ith just a number? I have a cell with the number 10 and the...

Hi try using data validation ('Data - Validation).: - Select the cells in column A (assumption you start in A1) - enter the following formula in the data...

Dear Sir/ Madam NABHI is NABHI We are pleased to inform you that the 39th complete Revised Edition of the book NABHI's Income Tax Guidelines & Mini Ready...

I'm doing a transition matrix (hazard rate method) using formula (trying to avoid using VBA under some company policy), but then, i'm stuck when it comes to...

I hid collom A and now can't unhide it! Please help?

Hi All, I would like to find the LAST NonBlank TEXT Cell in a Row and subtract the Column number of the Cell from the total number of Columns in the Row. Or,...

Hi I've looked at other posts and can't seem to find what I need so apologies if it is posted elsewhere. I have two columns, the first column has validation...

I have a report download that roughly looks like this: Part # Date Qty 1234 6/1/10 25 1234 6/3/10 50 1234 6/7/10 100 4567 6/1/10 ...