using excel 2003. i wish to identify the when text from one cell is repeated in another cell A2 Mrs Brown, 1 sample road, blurb city. B2 1 sample road C2...

Hello I'm trying to lookup and return a value but based on two conditions being satisfied. I key a code into A21 and a Length into F21 and return a value...

If Cell A1 = 5, and Cell B1 is greater than Cell A1, I'd like the fill color in B1 to be red. If Cell B1 is less than or equal to Cell A1, I'd like it to be...

I am trying to use pivot table data outside of the table and I when I drag the info from one line to the next, the pivot table information stays constant. I...

I am trying to count the number of entries within certain guidelines. Each time I try I keep coming up with errors or incorrect answers....

Here's my data: A B 1 10 120 2 15 80 3 12 30 I need a fast formula that can replace this one: (A1*B1)+(A2*B2)+(A3*B3) = 2760

Here's my data: A B 1 1-Jun-08 1-Jul-08 2 30-Jun-08 31-Jul-08 I need a formula in B1 and B2 that...

I would like to have a formula like this: ='maryssheet'!D111/'maryssheet'!D101 but the name of the sheet will change each name, let's say, to "harryssheet"...

I need to delete 2 columns that are the basis of a third column that combines the data in the first two columns. How can I do this and still have the third...

A B 10.000 1,262.61 What is the formula for saying A * B but not greater than B * .05

How do i colour code the values in my dropdown list ?

i have one big table, need help, how do to these things funcions 1. Need to count B5 to B35 names, how meny thimes names...

How can I concatenate three cells each with a number so that the concatenated cell is a number, not text? Example A1 B1 C1 D1...

I want to add 12 months to a start date (inclusive of the start date) and return the end date. Start date will only be the first or last day of the...

Is there a way to have your sheet tabs into a drop menu?

I have two validation lists, each have four options in their respective list with ranges of 4 to 1. I need a formula that will display the results of the...

Hello. I am wondering if anyone can help me. I have cells A1:D4. Column A has check #. Column B has allocation (meaning if I received a check and our...

Hello, I have 10 columns, AK to AT, that have codes in them. Each column contains the following codes: A0, A1, A2, A3, A5, A6, A7, A8, 49, 51, 52, 53, 54,...

I have a gross pay minus four deductions all in currency. My formula looked something like this: =sum(f3-(sumf4:f7)) which doesn't work. I tried a few...

Excel 2003 SP3 on WinXPPro 2002 SP3 I have a spreadsheet A:AA A Customer Name B Customer Address 3/Street C Customer Address 4/City/State D Product Name -...