+ Reply to Thread
Results 1 to 2 of 2

Placing a list of ranged numbers

  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Placing a list of ranged numbers

    I have a list of ranged numbers from 9 through 13 in column C and 2 columns ( A, B) of related information I want to pickup a particular number or numbers range including the related information (let's say only 11 and 13) and place on another worksheet.

    Sample:

    A B C

    3 009 9
    8 190 10
    7 092 11
    3 119 11
    7 129 12
    7 039 12
    5 409 13
    2 139 13

    I want to pick up just all information from column C - 11 and 13 on another worksheet

    Final sample:

    A B C

    7 092 11
    3 119 11
    5 409 13
    2 139 13

    I thinking its an array but just drawing a blank on this.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: Placing a list of ranged numbers

    maybe a Pivot table?
    Attached Files Attached Files
    Never use Merged Cells in Excel

+ 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