General

Deleting rows containing zeros
I am importing a variable amount (10,000+) rows of source data into an Excel 2002 worksheet. Many of the rows will contain zero in column B (total quantity) or zero in column C (total cost) which are not required. How can I automatically delete rows that contain zeros in BOTH columns? The intention is then to ra... 22 Apr 2010 11:23

Identify Differences Between four columns of data
I have 4 columns of data. The first two columns have 500 rows and the second two have 700 rows. I need to identify the differences between the columns. The data is representative of the following: Invoice # INV Amount Invoice # INV Amount 530878 0 530878 47.6 ... 22 Apr 2010 10:21

Pivot tables - Editing the data source shared by multiple pivot ta
Hi, I've got multiple pivot tables reports in an excel workbook that all share the same data source, which is a microsoft access query. I now want to add a couple of extra fields to the report ... so, i can add this to the microsoft access query, but it doesn't show up in the pivot table report automatically ... 22 Apr 2010 10:21

How do I delete clip art from cell in spreadsheet
I have tried "cut" and I have tried to "delete" clip art I inserted in cells in an EXCEL spreadsheet. ... 22 Apr 2010 10:21

Combo Box
Hi I am trying combo boxes for the first time in excel. I have created cells with validation lists with named ranges I have pinched the code below from Debra Dalgleish/Contextures and the problem is I have no understanding of what is going on and how to fix When I click into the cell with the validation list i... 22 Apr 2010 09:18

Auto concantenate
I am working in Office 2003. I am trying to create a spreadsheet that I can paste data into column a and automaticaly concantenate with a ; as the seperator. The catch is that my result needs to be limited to 1000 entries, I can have multiple cells with 1000 entries. example: 1234567-1;987654;1111111-11;456123... 22 Apr 2010 08:16

what row do I start an address for a window envelope?
nDoes anyone have any hady tips about which row on the xls spreadshet I need to start on so the recipient's adress block shows when I fold the invoice and post in a DL window envelope? ... 22 Apr 2010 08:16

Tax formula tests for multiple filing statuses and income amounts
A formula tests for three ranges of income levels for five filing statuses; depending upon the results, the taxpayer will receive a tax deduction for $4,000, $2,000, or $0 (i.e., no deduction) The table of ranges of income, filing statuses, and deduction ceilings are as follows: Legend: M-FJ (Married fil... 22 Apr 2010 07:13

How do i recover a file ive deleted by mistake?
I deleted it instead of opening it and its not in the recycle bin. ... 22 Apr 2010 14:31

request for a solution on shared documents
dear team, I work for an organisation that has more than 50 branches countrywide and more than 80 sales force. I need to collect sales data on a daily basis from every sales person. I have designed a standard excel templete uniform to all sales persons in it, is the daily sales targets vs actual sales..... How c... 22 Apr 2010 06:11