Results 1 to 11 of 11

Extracting data from table for related table

Threaded View

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Extracting data from table for related table

    I have the below table (snap shot of large data)


    I want to extract the starting & Ending Number for the below Name & Number, so how can I do that.Here please note that the

    Name Number Starting Number Ending Number
    B 01/2013B 123 135
    B 02/2013B 1500 1650
    B 03/2013B 1600 1760
    B1 01/2013B1 1750 1925
    B1 02/2013B1 500 550
    B1 04/2013B1 600 660
    B1 06/2013B1 800 880
    D 01/2013D 550 605
    D 05/2013D 650 715
    D 06/2013D 780 858
    D 02/2013D 850 935

    I want to extract the starting & Ending Number for the below Name & Number, so how can I do that. Here pleae note that in the above table the position of col 3 & 4 will keep changing (like, 6&10 or 8 & 15 respectively).

    Name Number Starting Number Ending Number
    B 01/2013B ? ?
    B1 02/2013B1 ? ?
    D 06/2013D ? ?

    Thanks,
    Last edited by ikavdiya; 05-27-2013 at 07:14 AM.

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