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

Can excel pick up totals on other sheets and workbooks for clients, where the clients information is never on the same row no. on each sheet, without it being...

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

Here is what I...

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

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

I thought I was getting this message when I refresh one pivot because I had multiple pivot tables on a worksheet. Whether I select Yes or No ("overwrite" or...

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

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

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

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

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

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

Hi A1 September 1, 2010 Years of Services Age A2 B2 C2 ...

I have a user who is using Excel as a database – ugh. One of their columns (fields) has contact data points. As an example, a cell might state –...

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

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