I've got two different spread sheets with large amount of data. These two charts however share one grout of data (in this case street address) The first set...

i need some help please. I know a little bit about excel, but im having some trouble combining formulas. this is what is in cell...

I would like to nest a function that would first filter the data in a column and then look for all of the "y" in that filtered column. I thought this would...

the first cell i click locks and it acts like the starting point of a range but i cant unclick from that cell. I have to end task to get out help

To Julie, Frank or any other lords of excel. I am trying to consolidate several spreadsheet into one=20 using the same template and format per sheet. Because...

On Sheet1 I have a Column of data, call it ColA. On Sheet2 I'd like to transfer Sheet1!A1 to Sheet2! A1...simple enough. =Sheet1!A1 entered in...

Hello everyone, I got a little problem with the pivot table report cause each time I do one, there some decimals that get add up some of my numbers like in my...

Is there a way to link part of the footer information to a cell in a spreadsheet? Someone I work with wants to have control over updating the revision date...

Hi, I have a column of $ amounts and corresponding dates in another column. Date Amount 1/1/04 $100.00 1/15/04 $100.00 1/31/04 ...

Randy wrote: in the range that contains the lookup value, there are multiple or duplicate entries, is there a function or formula that gives all...

I've copied a worksheet from another workbook. When I open the file to which I have copied the message states that there is a link to another file. I don't...

What is the function for calculating the componded annual growth rate?

I am trying to link information from our main office copy to our invoice copy so that when you enter the Co. information, etc that it transfers over. I have...

can I get the cube root of a number? All I see available is the square root.

Need a macro/function that'll delete every other column. THX Scottie

I am having a problem indirectly addressing a cell on a second worksheet (that is open). I found this article and when I tried the example it did now work...

hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when...

Hello there! Anybody could help me? I want to know if there is a way I could determine a duplicate entry about 10000 records becuase i do it manually: for...

I have a page of marketing leads with names, addresses, phone numbers, etc all running togeather on a MS Word doc. I want to copy it to a MS Excel spread sheet...

In one column, I have numbers (120-1200). In another column, I would like corresponding Alphabetical representaion of the numbers. Eg A1 = 123.56 then B1...