Results 1 to 9 of 9

Remove zeros from sheet

Threaded View

fusion007 Remove zeros from sheet 06-23-2011, 05:34 AM
watersev Re: Remove zeros from sheet 06-23-2011, 07:10 AM
snb Re: Remove zeros from sheet 06-23-2011, 07:20 AM
fusion007 Re: Remove zeros from sheet 06-23-2011, 07:26 AM
snb Re: Remove zeros from sheet 06-23-2011, 07:38 AM
  1. #1
    Registered User
    Join Date
    06-20-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    91

    Remove zeros from sheet

    Hi...I have a worksheet which is based on calculations from another worksheet. In effect it is copying data from one sheet to another.
    The issue I have is that after the calculations the worksheet pulls through lines that have zero amounts (I have a debit and credit amount columns - Columns I and J). I would like to remove the lines that have zero amounts in both columns I and J.
    Can anyone please help me with this? Thanks
    Last edited by fusion007; 07-04-2011 at 05:38 AM. Reason: More information

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1