Functions

extract data from pivottable which meets certain conditions
What is the correct formula for extracting data from a pivot table report which meets a certain conditional set of criteria? ... 4 Jun 2010 10:21

Size of file with pivot table
I have a file that was 8MB when I started. I created a pivot table pulling 7 fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot table would cause the file to be so large when the 8MB file already had pivot table sin it? When it was 8MB, it had 6 pivot tables. Now it's 20MB and it h... 4 Jun 2010 17:00

Calculating Bond Amortization using Excel functions
To do the calculation first you need to calculate yield to maturity. Then you create the the Bond Calendar by using Days360 function in Excel. Please note that corporate bond interest is calculated on a 360 day year basis. There are two flavors, one is US NASDAQ, and the other is European. Using this function you compu... 3 Jun 2010 20:10

Concatenation help
I have 3 cells I need to merge into one. One of the cells is a number anywhere from 1-16 or more. What I need is for the number in this cells to always be concatenated into a 2 digit number. Example: Cell A1 = USA123-4555678952 Cell A2 = CD Cell A3 = 4 I need the final output to be 234555678952CD04. So far ... 4 Jun 2010 13:41

Racking my brain on sumif
I have a report download that roughly looks like this: Part # Date Qty 1234 6/1/10 25 1234 6/3/10 50 1234 6/7/10 100 4567 6/1/10 75 4567 6/3/10 45 4567 6/7/10 20 I am trying to sum up the quantites for each part number by date into another worksheet. Help! ... 4 Jun 2010 18:07

Zeros displaying in cell when using = sign
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 a summary worksheet. All of a sudden I was see zeros (0) instead of the text I anticipated seeing. My cells are formatted the same (General), can someone... 3 Jun 2010 19:03

Zip Code Last 4 Digit as Zero
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 0000?. manually I've been doing this (01234 then add the last digit as -0000) which come to this 01234-0000. ... 3 Jun 2010 19:03

Pivot table in Excel 2007
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 ... 3 Jun 2010 20:10

Determine "on time" status
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 shipment was on time. What am I doing wrong? Column N Column O Scheduled Delivery Date / Time Actual Delivery Date / Tim... 3 Jun 2010 19:03

Challenging Formula Issue
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 out so here goes... I have four sheets of data that represent various international billing disputes. They all contain the date that the dispute was filed i... 3 Jun 2010 15:41