+ Reply to Thread
Results 1 to 2 of 2

Seat location range to individual rows per seat

  1. #1
    Registered User
    Join Date
    05-02-2022
    Location
    Buffalo NY
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2203 Build 16.0.15028.20218) 64-bit
    Posts
    1

    Seat location range to individual rows per seat

    Hello!

    I have a list of seat locations in a range. Section 100, row 1 seats 3-4 for example. I need those to be listed as one seat per row. 100 1 3, 100 1 4, instead. Attached is an example. Any ideas?

    Thank you!
    Attached Files Attached Files
    Last edited by MissyEagen; 05-04-2022 at 03:39 PM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,389

    Re: Seat location range to individual rows per seat

    Helper columns

    in E2

    =D2-C2+1

    copy down

    in F2

    =SUM($E$1:E2)+1

    Copy down

    In J2

    =INDEX(A$2:A$6,MATCH(ROWS($1:1),$F$1:$F$6))

    copy to K

    in L2

    =INDEX($C$2:$C$6,MATCH(ROWS($1:1),$F$1:$F$6))+COUNTIF($K$2:K2,K2)-1

    As you have 365 I am sure there will be a better solution
    Attached Files Attached Files
    Last edited by JohnTopley; 05-02-2022 at 11:57 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. [SOLVED] Seat auto asignment Help!
    By macnabong in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-06-2017, 10:38 AM
  2. [SOLVED] Complex formula to create seat assignment
    By didierkassas in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 02-15-2016, 01:12 PM
  3. Seat allocation with Date & Time
    By jayexcel1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-10-2014, 11:44 AM
  4. Seat number not found
    By jakeembx in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-14-2013, 02:29 PM
  5. Seat position finder, Indian Railway.
    By sreejith K K in forum Excel Tips
    Replies: 6
    Last Post: 07-15-2012, 02:45 PM
  6. Record Seat No every cell change on a range of cells
    By ORANGEGHOSt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-15-2011, 06:59 AM
  7. Seat Plan
    By natski in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-05-2006, 05:20 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