Results 1 to 6 of 6

Splitting table by category into groups of specific size.

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2022
    Location
    bristol
    MS-Off Ver
    2013
    Posts
    3

    Splitting table by category into groups of specific size.

    Hello all, I'm new to VBA and I'm struggling with solving a problem. I have spent days searching for a solution and now I'm stuck!!!
    Any help would be greatly appreciated.

    Table 1 is filled and can be any length. There is a finite number of test types. Each test type can have any number of samples (ID). I want to create a new table (Table 2) that splits test type into groups of three for all test types and leaves blank any slots within a group of specific test type that aren't filled.

    Please see attached file.

    Many Thanks!!
    Attached Files Attached Files
    Last edited by charles1234; 01-31-2022 at 06:10 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. classify each one of the 3 groups number of times in each category
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2018, 07:49 AM
  2. [SOLVED] splitting formula giving wrong answer in a particular for specific pack size description
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2018, 01:40 PM
  3. [SOLVED] Splitting frequency data by a category
    By mparker123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2014, 11:58 AM
  4. Filtering by text
    By saltarazan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-16-2013, 04:18 AM
  5. [SOLVED] Productsum: Highest Frequency Category, Specific Main Category, Frequency of Category
    By T86157 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2012, 12:43 PM
  6. Splitting a list into groups
    By tay4432 in forum Excel General
    Replies: 2
    Last Post: 07-12-2008, 04:54 PM
  7. Splitting Data into Groups
    By oliver79 in forum Excel General
    Replies: 1
    Last Post: 01-15-2008, 07:05 PM

Tags for this Thread

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