I have devised a Cash flow template which I now need to be able to sort date in the same row for so it can automatically calc brough t fwd invoices paid and...

I'm using a lookup_value,lookup_vector,result_vector function as an array formula to lookup first and last names in a two column array table and locate their...

My son has a severe handicap with his short term memory. I have made a spread sheet so that he can do some limited work for my business. He does ok, except for...

pleeeeeez I double dog dare ya

I need to know what are some of the uses for Vlookup and Hlookup functions. When they would be useful and the easiest way to use them.

How can I return a date, six months plus the first of the following month from a specified date? In other words, both January 1, 2005 and January 31, 2005...

I designed a sheet and colored filled every other row for aesthetic purposes. However after several days of data entry, I sorted the worksheet but...

Conditional Formating has only effected the cell or a string of text. I wish to change the entire worksheet to uppercase letters. Can this be done or will I...

The message I get is: Need two cells to return a result. Okay how do I assign such cells?

We share a workbook and my co-worker came to me today and insists she typed information in multiple cells which is now missing. We do track the history and...

Hi: Can someone please explain to me how to do the following?: I have 2 sheets (Sheet1 & Sheet2) in the same workbook. I want cell A1 of sheet1 to always show...

I have a spreadsheet with many columns. I would like to count how many occurances there are of two criteria matching. Example, If column A contains names of...

I have a provider directory with about 3,000 physicians that is set up as a vertical list in excel. Each physician is set up as: Physician's...

okay. So I am trying to workout a formula to compute a commision earning. Basically, if X amount of new business is made, then X*Y (corresponding Commision...

Hi, When adding a combo box for example, to edit the data source you need to go to properties. Somehow I've manged to change the format which I see...

I have a spread sheet built that currently has 382 sheets of data. The sheets are 12 columns x 61 rows. There are conditional formats applied. I can copy a...

I want to create a list of names and e-mail addresses in Excel then export this information to outlook express. I need to know how to get the names and...

Hi, Country Month Value Germany 1 100.00 Germany 5 250.00 UK 7 400.00 Spain 2 300.00 UK 5 250.00 Germany 9 710.00

Hi Country Product Value Germany Car 1,500.00 Germany Bike 200.00 Japan Bike 300.00 Japan Van 2,500.00 Japan Car 10,000.00 Based on the above...

I have extracted text data format thus i cant perform any maths calculation on the data. Thus i tried this logical test to convert the data into number. cell...