Functions

finding duplicate addresses across 2 worksheets in the same workbo
I have 2 spreadsheets within the same workbook that contains duplicate addresses. I need a macro or a formula to compare all of the addresses in a column with other addresses within that same column and the same column in the other worksheet to pull out duplicates over both worksheets. Any ideas? ... 12 Feb 2010 20:15

IF statement that yields a value based on a formula
Help! If cell B12 >= 0, then I need the answer to be calculated based on the formual "B12 * .40". If cell B12 < 0, then the answer is zero. How do I do this? -- barbara h ... 11 Feb 2010 15:05

IF THEN Statement
I need to do a calculation based on a cell. If cell B12 >= 0, then I need to calculate a formula (B13*.40). If cell B12 < 0, then value = 0. Can anybody help? -- barbara h ... 11 Feb 2010 12:49

Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
Hello, How can I format the number 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minutes and 7 seconds? Thank you! ... 11 Feb 2010 12:49

Can I 'embed' a formula to affect numbers as they're entered?
Ms Office Excel 2003 ( Ms Office Professional Edition 2003) I want to 'embed' a formula (eg: *.05) in multiple cells so that when data is then entered into the cells it operates on the data and displays the result. For instance, in the example given, if I then entered '16' into a cell the figure displayed woul... 11 Feb 2010 12:49

can I autopopulate from a long drop down list in Excel?
I have a very long list of referring physicians in a drop down list for data entry people to populate. I would like them to type in the first 3 characters and be immediately directed to that area of the drop down list. Is this possible? Thanks! ... 11 Feb 2010 10:34

Vlookup formula
Iam using vlookup formula and the ce;ll which has no value gives me #N/A. I want 0 there.How can I do that. Thanks Vijay ... 11 Feb 2010 08:19

how do i set up a user prompt at the start of an excel workbook ?
I need to create a security feature which requests the users agreement prior to entering into a worksheet. How do I do that? ... 11 Feb 2010 06:07

How can I stop format change when copying data into unlocked cells
How can I stop the format changing when I copy data into an unlocked cell in a format protected worksheet? I need to allow people to both enter data or copy data from another source into cells so I have unlocked these cells but also don't want the format of the cells to be changed. If you enter data directly ... 11 Feb 2010 12:49

Using the Icon Set for Conditional Formatting
Hi! I have a column of currency values that I'm trying to conditionally format with the arrow icon set (red, green, yellow). What I'm trying to do is format the currency value with one of the arrows based on its relation to the previous cell in the column. c4 shows $234.22 c5 shows $319.87 c6 shows $111.... 10 Feb 2010 21:22