Results 1 to 5 of 5

extracting page number ranges based on prefix of sorted data

Threaded View

  1. 09-06-2016, 03:19 PM #1
    wdjohnson
    wdjohnson is offline
    Registered User
    Join Date
    12-13-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2010
    Posts
    12

    extracting page number ranges based on prefix of sorted data

    Hello, I'm trying to sort the following as attached file shows to give page ranges of specific categories. Can you guys help me with an elegant solution with formulas no vbas?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to paste sorted data in specific ranges in sheet2
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2015, 09:40 AM
  2. set number of pages to print based on data on the page
    By MATT.B in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2014, 05:33 PM
  3. Can a sheet with locked data be sorted without setting 'Allow users to edit ranges'?
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2014, 09:46 PM
  4. Extracting data from web page
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2014, 10:44 AM
  5. [SOLVED] Extracting Data From Charts Using Ranges (V-Lookup W/ Ranges?)
    By Kolin in forum Excel General
    Replies: 9
    Last Post: 04-14-2012, 05:39 PM
  6. Extracting rows based on multiple ranges and unique numbers
    By D13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2012, 09:33 AM
  7. extracting page number from page setup footer
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2008, 01:43 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1