+ Reply to Thread
Results 1 to 19 of 19

Index Row and return data in a Single Column:No return

  1. 09-05-2005, 10:05 PM #1
    Domenic
    Guest

    Index Row and return data in a Single Column:No return

    Try...

    A8, copied down:

    =INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Hope this helps!

    In article <519B554A1A7AE@OfficeKB.com>,
    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote:

    > Hi All,
    >
    > How do I Index a Row of Text values in one Sheet and Return the Text data to
    > a NEW Sheet in one Column?
    >
    > Sample - Row of Text data - Sheet 1
    > Columns B C D E
    > RowNo. 1 41-42 50-51 55-56 59-60
    >
    > If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
    >
    > Expected Results - returned in Column A - New Sheet
    > Column A
    > RowNo.8 41-42
    > RowNo.9 50-51
    > RowNo.10 55-56
    > RowNo.11 59-60
    >
    > Thanks
    > Sam
    Reply With QuoteRegister To Reply
  2. 09-05-2005, 10:05 PM #2
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return

    Do you just mean

    =INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

    --
    HTH

    Bob Phillips

    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
    news:519B554A1A7AE@OfficeKB.com...
    >
    > Hi All,
    >
    > How do I Index a Row of Text values in one Sheet and Return the Text data
    to
    > a NEW Sheet in one Column?
    >
    > Sample - Row of Text data - Sheet 1
    > Columns B C D E
    > RowNo. 1 41-42 50-51 55-56 59-60
    >
    > If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
    >
    > Expected Results - returned in Column A - New Sheet
    > Column A
    > RowNo.8 41-42
    > RowNo.9 50-51
    > RowNo.10 55-56
    > RowNo.11 59-60
    >
    > Thanks
    > Sam
    >
    >
    > --
    > Message posted via http://www.officekb.com


    Reply With QuoteRegister To Reply
  3. 09-05-2005, 10:05 PM #3
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return


    "Domenic" <domenic22@sympatico.ca> wrote in message
    news:domenic22-500627.11132020072005@msnews.microsoft.com...
    > Try...
    >
    > A8, copied down:
    >
    > =INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Clever!


    Reply With QuoteRegister To Reply
  4. 09-05-2005, 10:05 PM #4
    Sam via OfficeKB.com
    Guest

    re: Index Row and return data in a Single Column:No return


    Hi Domenic,

    Thank you very much - Formula works great!

    >A8, copied down:
    >=INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Cheers
    Sam


    Domenic wrote:
    >Try...
    >
    >A8, copied down:
    >
    >=INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))
    >
    >Hope this helps!
    >
    >> Hi All,
    >>
    >[quoted text clipped - 16 lines]
    >> Thanks
    >> Sam


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  5. 09-05-2005, 10:05 PM #5
    Sam via OfficeKB.com
    Guest

    re: Index Row and return data in a Single Column:No return


    Hi Bob,

    Thank you for very much for alternative solution - also works great!

    >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

    Cheers
    Sam


    Bob Phillips wrote:
    >Do you just mean
    >
    >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    >
    >> Hi All,
    >>
    >[quoted text clipped - 16 lines]
    >> Thanks
    >> Sam


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  6. 09-05-2005, 10:05 PM #6
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return

    Domenic's is cleverer, mine is more understandable <vbg>

    --
    HTH

    Bob Phillips

    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
    news:519C5C034A568@OfficeKB.com...
    >
    > Hi Bob,
    >
    > Thank you for very much for alternative solution - also works great!
    >
    > >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    >
    > Cheers
    > Sam
    >
    >
    > Bob Phillips wrote:
    > >Do you just mean
    > >
    > >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    > >
    > >> Hi All,
    > >>
    > >[quoted text clipped - 16 lines]
    > >> Thanks
    > >> Sam
    >
    >
    > --
    > Message posted via OfficeKB.com
    > http://www.officekb.com/Uwe/Forums.a...tions/200507/1


    Reply With QuoteRegister To Reply
  7. 09-05-2005, 11:05 PM #7
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return

    Domenic's is cleverer, mine is more understandable <vbg>

    --
    HTH

    Bob Phillips

    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
    news:519C5C034A568@OfficeKB.com...
    >
    > Hi Bob,
    >
    > Thank you for very much for alternative solution - also works great!
    >
    > >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    >
    > Cheers
    > Sam
    >
    >
    > Bob Phillips wrote:
    > >Do you just mean
    > >
    > >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    > >
    > >> Hi All,
    > >>
    > >[quoted text clipped - 16 lines]
    > >> Thanks
    > >> Sam
    >
    >
    > --
    > Message posted via OfficeKB.com
    > http://www.officekb.com/Uwe/Forums.a...tions/200507/1


    Reply With QuoteRegister To Reply
  8. 09-05-2005, 11:05 PM #8
    Sam via OfficeKB.com
    Guest

    re: Index Row and return data in a Single Column:No return


    Hi Bob,

    Thank you for very much for alternative solution - also works great!

    >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

    Cheers
    Sam


    Bob Phillips wrote:
    >Do you just mean
    >
    >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    >
    >> Hi All,
    >>
    >[quoted text clipped - 16 lines]
    >> Thanks
    >> Sam


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  9. 09-05-2005, 11:05 PM #9
    Sam via OfficeKB.com
    Guest

    re: Index Row and return data in a Single Column:No return


    Hi Domenic,

    Thank you very much - Formula works great!

    >A8, copied down:
    >=INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Cheers
    Sam


    Domenic wrote:
    >Try...
    >
    >A8, copied down:
    >
    >=INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))
    >
    >Hope this helps!
    >
    >> Hi All,
    >>
    >[quoted text clipped - 16 lines]
    >> Thanks
    >> Sam


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  10. 09-05-2005, 11:05 PM #10
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return


    "Domenic" <domenic22@sympatico.ca> wrote in message
    news:domenic22-500627.11132020072005@msnews.microsoft.com...
    > Try...
    >
    > A8, copied down:
    >
    > =INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Clever!


    Reply With QuoteRegister To Reply
  11. 09-05-2005, 11:05 PM #11
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return

    Do you just mean

    =INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

    --
    HTH

    Bob Phillips

    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
    news:519B554A1A7AE@OfficeKB.com...
    >
    > Hi All,
    >
    > How do I Index a Row of Text values in one Sheet and Return the Text data
    to
    > a NEW Sheet in one Column?
    >
    > Sample - Row of Text data - Sheet 1
    > Columns B C D E
    > RowNo. 1 41-42 50-51 55-56 59-60
    >
    > If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
    >
    > Expected Results - returned in Column A - New Sheet
    > Column A
    > RowNo.8 41-42
    > RowNo.9 50-51
    > RowNo.10 55-56
    > RowNo.11 59-60
    >
    > Thanks
    > Sam
    >
    >
    > --
    > Message posted via http://www.officekb.com


    Reply With QuoteRegister To Reply
  12. 09-05-2005, 11:05 PM #12
    Domenic
    Guest

    re: Index Row and return data in a Single Column:No return

    Try...

    A8, copied down:

    =INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Hope this helps!

    In article <519B554A1A7AE@OfficeKB.com>,
    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote:

    > Hi All,
    >
    > How do I Index a Row of Text values in one Sheet and Return the Text data to
    > a NEW Sheet in one Column?
    >
    > Sample - Row of Text data - Sheet 1
    > Columns B C D E
    > RowNo. 1 41-42 50-51 55-56 59-60
    >
    > If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
    >
    > Expected Results - returned in Column A - New Sheet
    > Column A
    > RowNo.8 41-42
    > RowNo.9 50-51
    > RowNo.10 55-56
    > RowNo.11 59-60
    >
    > Thanks
    > Sam
    Reply With QuoteRegister To Reply
  13. 09-06-2005, 04:05 AM #13
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return

    Domenic's is cleverer, mine is more understandable <vbg>

    --
    HTH

    Bob Phillips

    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
    news:519C5C034A568@OfficeKB.com...
    >
    > Hi Bob,
    >
    > Thank you for very much for alternative solution - also works great!
    >
    > >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    >
    > Cheers
    > Sam
    >
    >
    > Bob Phillips wrote:
    > >Do you just mean
    > >
    > >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    > >
    > >> Hi All,
    > >>
    > >[quoted text clipped - 16 lines]
    > >> Thanks
    > >> Sam
    >
    >
    > --
    > Message posted via OfficeKB.com
    > http://www.officekb.com/Uwe/Forums.a...tions/200507/1


    Reply With QuoteRegister To Reply
  14. 09-06-2005, 04:05 AM #14
    Sam via OfficeKB.com
    Guest

    re: Index Row and return data in a Single Column:No return


    Hi Bob,

    Thank you for very much for alternative solution - also works great!

    >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

    Cheers
    Sam


    Bob Phillips wrote:
    >Do you just mean
    >
    >=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)
    >
    >> Hi All,
    >>
    >[quoted text clipped - 16 lines]
    >> Thanks
    >> Sam


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  15. 09-06-2005, 04:05 AM #15
    Sam via OfficeKB.com
    Guest

    re: Index Row and return data in a Single Column:No return


    Hi Domenic,

    Thank you very much - Formula works great!

    >A8, copied down:
    >=INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Cheers
    Sam


    Domenic wrote:
    >Try...
    >
    >A8, copied down:
    >
    >=INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))
    >
    >Hope this helps!
    >
    >> Hi All,
    >>
    >[quoted text clipped - 16 lines]
    >> Thanks
    >> Sam


    --
    Message posted via OfficeKB.com
    http://www.officekb.com/Uwe/Forums.a...tions/200507/1
    Reply With QuoteRegister To Reply
  16. 09-06-2005, 04:05 AM #16
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return


    "Domenic" <domenic22@sympatico.ca> wrote in message
    news:domenic22-500627.11132020072005@msnews.microsoft.com...
    > Try...
    >
    > A8, copied down:
    >
    > =INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Clever!


    Reply With QuoteRegister To Reply
  17. 09-06-2005, 04:05 AM #17
    Bob Phillips
    Guest

    re: Index Row and return data in a Single Column:No return

    Do you just mean

    =INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

    --
    HTH

    Bob Phillips

    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
    news:519B554A1A7AE@OfficeKB.com...
    >
    > Hi All,
    >
    > How do I Index a Row of Text values in one Sheet and Return the Text data
    to
    > a NEW Sheet in one Column?
    >
    > Sample - Row of Text data - Sheet 1
    > Columns B C D E
    > RowNo. 1 41-42 50-51 55-56 59-60
    >
    > If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
    >
    > Expected Results - returned in Column A - New Sheet
    > Column A
    > RowNo.8 41-42
    > RowNo.9 50-51
    > RowNo.10 55-56
    > RowNo.11 59-60
    >
    > Thanks
    > Sam
    >
    >
    > --
    > Message posted via http://www.officekb.com


    Reply With QuoteRegister To Reply
  18. 09-06-2005, 04:05 AM #18
    Domenic
    Guest

    re: Index Row and return data in a Single Column:No return

    Try...

    A8, copied down:

    =INDEX(Sheet1!$B$1:$E$1,ROWS($A$8:A8))

    Hope this helps!

    In article <519B554A1A7AE@OfficeKB.com>,
    "Sam via OfficeKB.com" <forum@OfficeKB.com> wrote:

    > Hi All,
    >
    > How do I Index a Row of Text values in one Sheet and Return the Text data to
    > a NEW Sheet in one Column?
    >
    > Sample - Row of Text data - Sheet 1
    > Columns B C D E
    > RowNo. 1 41-42 50-51 55-56 59-60
    >
    > If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60
    >
    > Expected Results - returned in Column A - New Sheet
    > Column A
    > RowNo.8 41-42
    > RowNo.9 50-51
    > RowNo.10 55-56
    > RowNo.11 59-60
    >
    > Thanks
    > Sam
    Reply With QuoteRegister To Reply
  19. 09-06-2005, 04:05 AM #19
    Sam via OfficeKB.com
    Guest

    Index Row and return data in a Single Column


    Hi All,

    How do I Index a Row of Text values in one Sheet and Return the Text data to
    a NEW Sheet in one Column?

    Sample - Row of Text data - Sheet 1
    Columns B C D E
    RowNo. 1 41-42 50-51 55-56 59-60

    If the above is misaligned: B1=41-42, C1=50-51, D1=55-56, E1=59-60

    Expected Results - returned in Column A - New Sheet
    Column A
    RowNo.8 41-42
    RowNo.9 50-51
    RowNo.10 55-56
    RowNo.11 59-60

    Thanks
    Sam


    --
    Message posted via http://www.officekb.com
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1