+ Reply to Thread
Results 1 to 2 of 2

Filter based on a column of items

  1. #1
    Pasko1
    Guest

    Filter based on a column of items

    I have a range of data 500 rows high x 5 columns wide. I want to filter the
    range by comparing the values in the first column to a separate range in 92
    rows high (x 1 column wide). I want the whole range to therefore be 92 rows
    high x 5 columns wide, with the first column equal to the "lookup" range. I
    do not want to use Vlookup.

  2. #2
    CyberTaz
    Guest

    Re: Filter based on a column of items

    You might look at Data>Filter>Advanced Filter.

    HTH |:>)



    On 8/22/05 5:16 PM, in article
    08C0F7F3-9A0D-458D-B040-E56B25843F39@microsoft.com, "Pasko1"
    <Pasko1@discussions.microsoft.com> wrote:

    > I have a range of data 500 rows high x 5 columns wide. I want to filter the
    > range by comparing the values in the first column to a separate range in 92
    > rows high (x 1 column wide). I want the whole range to therefore be 92 rows
    > high x 5 columns wide, with the first column equal to the "lookup" range. I
    > do not want to use Vlookup.



+ 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