I have 2 pivot tables that use the same data source. Each has the same Field (Field1) in the Page Area. Is there a way to link the Item selection in the...

I have been staring at the screen too long I think trying to fix this. I waive the white flag in concession and ask for help. Here is an example of my...

using Excel 2003 I have taken the following from the Excel Help. I cannot Understand exactly how this function works. 10% Annual interest 1 Period for which...

Hi Excel Masters, I think there would be a way to this but i wouldn't know where to begin. I am working in Office 2007 1st off and I have a large customer...

I have 2 different products with 2 different licensing methods in my final tally sheet I want an statement to help me do this If part number in C3 = Y,X,Z and...

I have a main worksheet with many links to another worksheet tab. That other secondary worksheet contains data that will now be collected differently (not in...

Please give me a sample and show the diff. from currency $ sign. Thanks for help.

Is it possible to do this. IF 0 value in a cell, I want to (from another cell) return another's cell to the original cell with a 0 value. Please email me...

Hi, Can you help make this formula shorter/better/more efficient - I need to go up to 90th...

I have a number in cell A1 that counts the rows in use, say 11000. I have a hyperlink that I use to go to the bottom of the spreasheet in cell A2 to reference...

I have a formula =(IF(U7100,"Fail","Pass") posted in cell T7 but if U7 is blank T7 is populated with Pass. If U7 is blank I need T 7 to be blank as well.

Can colums be locked so that they do not expand in width? -- gueyo

Hi, In Column A I have a list of random numbers, in Column B I have the words 1st, 2nd 3rd right upto 90th. In column C I have the following formula which...

I have a several column worksheet. There may be several cells within those colunms that have duplicate data. How do I set up some kind of formula to find...

This seems like a simple thing but none of us here can figure it out. I have a date prompt that works as is, with a "=". Range("AO1").Select Dim...

I cannot seem to get the Euro symbol to display correctly in Excel. I enter the symbol using either ALT 0128 or the InsertSymbol function, but as soon as I...

How to make a picture as hyperlink?

I am reasonably new to Excel and having a couple of problems. The first is the following which is probably to do with formatting. =IF(B280.01,1) is what it...

I have an excel sheet that has a series of measurements in which the inch marks have been left out. How do I get from here 2-1/16 x 6-3/8 x 3-1/2 2-7/16 x...

Now that I have my vlookup working I now have a new situation I have a customer number which I use my vlookup to get data such as Cust name renewal...