I HAVE 6 DIFFERENT CURRENCIES AND NEED TO PUT THESE CURRENCIES IN A FORMUAL SO THAT THE AMOUNT PAID HAS ITS CORRECT CURRENCY SYMBOL. THE CURRENCIES ARE $USD,...

Hi, On one of my workbooks (Excel Windows XP Pro), I have information on separate worksheets (sheet 1, sheet 2, sheet 3, etc). On my last sheet, I would like...

In column B I have text that may or may not contain the word "foo". In column D I have cells that may or may not contain text. I want to be able to count the...

I have a column of account numbers listed as follows: US1234 6789 1234-12345 ABC/ABC62 What I am trying to do is to take the text and/or numbers before the...

need three colors to display...one for numbers 250 and above, one for numbers between 200 and 249, and one for numbers below 200. There is no formula entered...

Is there a simple way to compare the values in 12 cells, and then return the largest value in the 13th cell. I could do this with a complex AND, OR series but...

Hi there, can anyone help me? If I've got a figure in a spreadsheet, say £5,678,123 and I want this figure to be shown as £5.68 (as in £5.68 million), is...

Hello I have a countif function... =COUNTIF(D3:D59,"0") However I need to also incorporate into this to flag 3 rows that I don't want to include in this...

Hey all! I hope you guys can provide some insight to this. I have a project that's due on Friday morning, but can't seem to get this formula figured...

I have my data like so: ColA ColB 1 A 1 B 2 A 2 B 1 C 1 D

Hi! Given are the following columns e.g.: Surname and Name. In a third column I would like to paste the contents of these cells together to create an email...

I want to copy the subject and date from the Outlook mail list window to an excel file and sort them mail headings/date received and then find how...

How do I copy the contents of a cell from one workbook to another (as a formula)? I tried '=worksheet name!cell name' but that doesn't seem to work

I have used the conditional sum wizard for many times , but i found that if you give it mare than 4 conditions and the database in a differnet sheet , after...

I have a 3 page document in excel 2002 and want the header to only display on the first page. I want to use the space on the 2nd and 3rd page for...

If I create a spreadsheet that is wider than one page, how do I get it to all print on one page? Used to have this functionality on another computer but can't...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

Hi, thanks for any answer: In sheet 1, colB, I want to check if ref. in colA also exists in sheet2col.A, if yes, then return its valu from sheet2col.C,...

I saw some other post about kind of the same problem but not this way. I have a risk evaluation formula in a cell. Output range is between 1 and 9 If between...

I have a table of monthly sales by office so it looks something like this: a b c d e f etc. 1 ...