Results 1 to 4 of 4

Sorting on Visible Rows Only

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2010
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Sorting on Visible Rows Only

    Haven't been able to find an answer to this anywhere. I have a table with hidden rows. Each hidden row is associated with the visible row immediately on top of it (matched by column L). When I sort on column B, the hidden/associated rows are sorted too, and they lose their adjacency to the row they're related to (because the hidden rows have different values in column B).

    Is there any way to only sort on visible rows, keeping the hidden row association adjacent to its visible counterpart?

    Sample file is attached...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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