+ Reply to Thread
Results 1 to 6 of 6

Every 5 groups of rows

Hybrid View

ksclans Every 5 groups of rows 08-01-2010, 09:36 PM
stanleydgromjr Re: Every 5 groups of rows 08-01-2010, 10:40 PM
ksclans Re: Every 5 groups of rows 08-02-2010, 04:40 PM
stanleydgromjr Re: Every 5 groups of rows 08-02-2010, 07:11 PM
JBeaucaire Re: Every 5 groups of rows 08-02-2010, 07:58 PM
Marcol Re: Every 5 groups of rows 08-02-2010, 08:01 PM
  1. #1
    Registered User
    Join Date
    08-01-2010
    Location
    Seattle
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Every 5 groups of rows

    well if B1 can have a new line within the cell when transfer content A1 - 5 that would be better... so looks like
    "
    1
    11
    111
    1111
    11111
    "

    what I am trying to do is to select groups of 5s without using my mouse to select them and counting 1, 2, 3, 4, 5.. if this works then I just need to select one cell.. thanks

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Every 5 groups of rows

    ksclans,

    Can I see a workbook with examples of numbers in column A, A1 thru A15, and what column B will look like?

    Please post your workbook (or a sample) by clicking on the New Post button, then scroll down and click on the Manage Attachments button.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1