I have just recently started to use Array formula that return multiple results. eg, select a range of cells 1 column x 8 rows and...

I am trying to create an IF formula that if a column is 16 but 49 then multiple by .75 or if the number is 8 but 15 ten multiple by .50, if greater than 50...

I have been using MSNStockQuotes on a few computers without any problems for months. Now (in the last day or so) , when I press "update Quotes" on any of the...

I have a cell refering to another workbook. example: April.xls I want to change all cells with that refrence but without changing each one individually, so i...

I'm currently designing a worksheet that contains all of our department tasks. Each task may have one of the following status: Open, On-going, For Review /...

I set A1="1978-9-22", B1="find("-",A1)" and return, but B1 shows #VALUE!, why? How can I resolve it? thanks in advance. A B ...

I have two EXCEL 2000 workbooks( Estimates.xls and Prices.xls). Workbook 'Estimates.xls' has 1 worksheet with empty cells (C&D) that need populating if...

Excel 2007, SP1 on Vista I turned a rectangular region (with column headings) into a Table (for ease of adding new rows, etc) in a workbook - it's Table15 in...

I have a list of values in collum A and I wantto keep a running talle in another colulm B is there an easyier way to do this than putting the sum formular in...

Hi, I have a bunch of forumla's in a worksheet and when I copy either the tab or select the entire worksheet and paste it into a new workbook it...

I am using windows xp and want to cross reference two excel spreadsheets and take out any duplicated data. How do i do this?

Hi again, I've came up with another problem. The thing is like this. In a worksheet I have 7 coulms to use (a,b,c,d,e,f,g). The first one (a) is the most...

How can Auto numbe an invoice I am working on in Excel. I use to be able to do it in Office 97. View-Toolbars-invoice and then click on auto number. In office...

I confused about creating formula using if function for the condition below. Labor costs for items with material costs of at least $100 but less than $500 are...

I am trying to enter a formula in a worksheet. I want the formula to do the following: IF A1=40 then enter 1, if less that 40 enter 0, OR IF A1=45 enter 2,...

Hi, I am creating a model in excel using range names for every row which works really well. The model is run across several years which are allocated a column...

Excel 2003 does not allow me to work from a pivot table in the same way Excel 2000 did. When pointing and clicking to a cell in a pivot table, the formula is...

www.exceluserconference.com/2006ECEUC.html Everyone who registers this week will be entered into a drawing for Patrick O'Beirne's book Spreadsheet Check and...

I have a worksheet that I enter time values into individual cells: A1 = 6:00 B1 = 12:00 C1 = 12:45 D1 = 17:15 When I enter these values, I would like some of...

I have a large number of cells with date and time like this, "Jan 12, 2001 5:55 pm" I want to truncate the time in the cell and only make it display...