Results 1 to 4 of 4

Number of rows between same data in two columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-22-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Office 2019
    Posts
    310

    Number of rows between same data in two columns

    Hi all.

    I have two columns in which specific names of items exist. I need to be able to show as a table the amount of rows between where the specific name exists.

    The Data columns and Specific item lists are dynamic and can be of any length.

    I've attached an example of what I'm trying to achieve.

    Many thanks in advance

    Frankie
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Carry down formula for columns based on the number of rows filled with data
    By shre0047 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2016, 10:18 AM
  2. Add x number of columns and rows with certain data in it.
    By Nick_Winchester in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2014, 12:17 AM
  3. Replies: 9
    Last Post: 05-28-2014, 03:27 AM
  4. count columns with data then insert that number of rows
    By johnson1421 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2014, 06:54 PM
  5. [SOLVED] Getting data from columns into rows - needs to match employee number
    By HDuff in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2013, 06:13 AM
  6. [SOLVED] Macro to Reverse Order of Columns but Dependent on Number of Data Rows
    By francois28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 06:34 PM
  7. Data from a number of rows and columns to one column
    By mark_h82 in forum Excel General
    Replies: 2
    Last Post: 01-14-2005, 11:07 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