I have been having serious trouble trying to sort this out. It is a little complicated and I will score major points with my supervisor if I can sort this...

Hi All I have data listed in rows that I want to display in columns which will then be used in another program and I can't use a pivot table. ...

I was moving along very well gathering information form several other worksheets in my workbook by using the = sign to display text from the worksheets into...

I have a Zip Code Table with only the first 5 digits and do not have the last 4 digit. How can I make them in 9 digit zip code with the last 4 digit as...

I'm trying to write a formula to determine if a delivery is on time. In the example below, I used =IF(O6=N6,"Yes","No") and Excel returned "No", but this...

Does anyone have an elegant way of concatenating a series of cells? I think the answer will be a user defined function which will be equivalent to...

I have a list of 600+ zip codes that are curently in individual cells. I need to turn them into one list separated by commas. Is this possible? The best...

Anyone know of a function that calculates the bond premium amortization using the constant yield method? An example of a bond premium that would need...

I am printing alot of charts for one spreadsheet that contains many tabs. I would like each page printed to have the name of the tab, so I did the...

Hi, Somehow my Pivot table do not sums up by rows. Boxes are checked for both columns and rows for Grand total under options, Tools and Filter. Dinesh

I need to create several different pivot tables from the same set of data. However, I need to keep switching between the different tables and it quickly...

Sir, I am using MS excel 2003. I try to get data (a1:u17000) from another file using "Import external data" function. When I refresh data, not all data...

I have 5 categories that I need to sum but it is on another tab. I can't remember how to use the Sumif and vlookup formula together. Product A = 100 Product...

I have a column listing numbers in worksheet B. I'm looking for a formula to place in worksheet A that will list the bottom number listed in that worksheet...

I hid collom A and now can't unhide it! Please help?

Super expert, If I have cell containing a series of data like this .... 1,12,9 1,2,9 1,22,17,18 23,23,1,9 24,21,1 1,23,11

I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM, SAS and CCleaner, Office 2007. All of a sudden only one (of many) worksheets...

Is it possible to compute an average given a criteria. For example, I have some data like this: 30 Day High30 Day...

I have the following replace info in a macro. Selection.Replace What:="Of", Replacement:= _ " of ", LookAt:=xlPart, SearchOrder:=xlByRows, _ ...

Was this function removed from 2007 or do I just need to download an add-in?