+ Reply to Thread
Results 1 to 2 of 2

How to separate particular item from list?

  1. #1
    Registered User
    Join Date
    09-18-2008
    Location
    Australia
    Posts
    37

    How to separate particular item from list?

    I have a list of various payments in columns in a spreadsheet. At the end of the financial year (Australia) I must isolate a particular set of payments (e.g. SH or Interest) into new columns containing those payments only, beginning on 1/7/11 to 30/06/12 (Years change). I hope I have made myself clear TIA Terry

    I have added the correct Excel file (I hope)

    I have now added the file (Book 1a) with columns J, K, L & M to indicate what I want to achieve. In other words I want to separate out rows 5, 8, 13 & 16 etc. I hope I have clarified the situation and thanks for the reply.
    Attached Files Attached Files
    Last edited by thalt; 05-10-2012 at 02:16 AM.

  2. #2
    Forum Contributor
    Join Date
    03-31-2009
    Location
    Childers QLD, Australia
    MS-Off Ver
    Excel 2003, 2007 & 2013
    Posts
    128

    Re: How to separate particular item from list?

    Hi,

    I put your figures into a spreadsheet to see what you had.

    I have used "ISNUMBER" AND "FIND" functions to achieve a result.

    Look at formula's in columns "I" and "L"

    I hope this may suit.

    Cheers

    TonyB
    Attached Files Attached Files

+ Reply to Thread

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