Hi guys, Need help with the question detailed below. In my Pivot Table: Field "Qty" is xlDataField. Field "Quarter" is xlColumnField. The report shows the...

Hi guys, Need help with the question detailed below. In my Pivot Table: Field "Qty" is xlDataField. Field "Quarter" is xlColumnField. The report shows the...

=(SUM(I5:U5))+F5-(COUNTA(I5:U5)*15) this gives me a plus/minus balance for a team roster in Col A, dates are in the range, which is added if they paid money...

Do we have sorting for the rows same as for columns. If suppose I want to hide the columns containing blank cells in a perticular row.can I do it or can I...

I build a catalog for coins collection with Excel. each row represents a coin (record). in two cells (fields) i have a path to both sides of the coin scanned...

Hi In my Excel worksheet there are two columns A & B. A contains the product codes and B contains the customer codes. How can I count the number of UNIQUE...

Hi, I have built a simple pivot table with 2 columns : Amounts and count of amounts eg: amount/Nb of amount 100 /1 150 /5

=IF(O6=P6,P6*K6/J6,IF(O6P6,O6*K6/J6,IF(O6P6,P6*K6/J6+AQ6*K6/J6*1.5,IF(U6=V6,V6*K6/J6,IF(U6V6,U6*K6/J6,IF(U6V6,U6*K6/J6+AU6*K6/J6*1.5,IF(aa6=ab6,ab6*K6/J6,IF...

can excel 2007 be used to make a invoicing system that will increment and save each invoice.

Is it possible to copy formatting (headers, margins, etc) from one sheet to another? I need to add sheets to a workbook that are set up just like an existing...

hi, I am making a church donation file in Excel. We have now about a hundred plus donors. The number of new donors are still increasing. At present, I am...

I have data ("Usage") with hours 1-24 as the column headers and dates Jan 1-Dec 31 in rows 1-365 for user 1, rows 366-733 for user 2, etc... for 1200 users. ...

In my system, I have an Excel 2003 custom toolbar saved in a file called Excel11.xlb. I have also created a custom toolbar in VBA. Can anyone tell me where it...

I have just added this on a work sheet. It works OK when sheet is unprotected but when I protect the sheet it comes up error 400. If I select Insert row on...

I have 3 years worth of daily data in a spreadsheet. To "normalize" the data, I am requred to add the first cell value to each of the subsequent...

Hi, I need to convert 3 columns into 1, as text. Column C has a direction, North or South, Column D has a route number, 535, 510, 511, and Column E has and...

I have a formula that divides the quantity in one cell by the quantity in another cell to give me a result in a third cell. It's designed to give me labor...

The "Ribbon" seems to have killed custom menu creation. Are there any other new features to help me organize and quickly access my Macros?

I have a list of names in a column and want to show the total number of entries in the column at the bottom. -- Max

Hi, What I want to do is find the top 3 highest scores with (Large(P3:p95,row(A1)) and then get the ajacent values from row (O) and row (R)