+ Reply to Thread
Results 1 to 4 of 4

Filtering a Range

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    763

    Filtering a Range

    Hi,

    In the attached file I have created a lookup table in columns A to C that extract in alphabetical order into column A the product names from column M for which the data is flagged as “non-lagged”. In columns B and C the relative performance of these products is calculated.

    I would like then to sort the data in the lookup table in descending order of the values in column C. However, this doesn’t seem to work properly as the values in C seem to be regarded as text even though they’re formulae.

    Could someone please have a look at this and also suggest if it’s possible to add a filter button to column C so that the table can be sorted with one click.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Filtering a Range

    This as an option.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    763

    Re: Filtering a Range

    That's great, thanks very much

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Filtering a Range

    You are welcome and thanks for the feedback & rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filtering a range of cells, based on another range
    By MBTDavid in forum Excel General
    Replies: 1
    Last Post: 09-02-2013, 04:27 PM
  2. [SOLVED] Filtering on date range, but capturing items that 'straddle' the range
    By Kite3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2013, 05:38 AM
  3. VBA Code Help with Range Filtering
    By Wes88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2012, 01:53 AM
  4. Filtering a range.
    By jal1 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-29-2007, 06:38 PM
  5. [SOLVED] Filtering a Date Range
    By Leslie P via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-11-2005, 12:05 PM

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