+ Reply to Thread
Results 1 to 6 of 6

counting and naming unequal data in unequal length rows

  1. #1
    Registered User
    Join Date
    05-23-2017
    Location
    UK
    MS-Off Ver
    14.4.0
    Posts
    4

    counting and naming unequal data in unequal length rows

    Hello,

    I am trying to number and rename data. I cannot use the replace function because the spreadsheet is extremely large.

    Data in column A occupies a different length (for example 001ifpim occupies 4 rows but 002ifpim only 1). I need to rename all the 001ifpim as 001; all the 002ifpim as 002.
    The attached screenshot should make clear what I am trying to do.
    Is there a formula to do this?

    Thank you!

    Screen Shot 2017-05-26 at 2.28.48 PM.png

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: counting and naming unequal data in unequal length rows

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: counting and naming unequal data in unequal length rows

    Try this:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: counting and naming unequal data in unequal length rows

    Another

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: counting and naming unequal data in unequal length rows

    Does this help?

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: counting and naming unequal data in unequal length rows

    Or:

    Please Login or Register  to view this content.

+ 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] Lining up data with two colums of unequal length
    By tdr0007 in forum Excel General
    Replies: 6
    Last Post: 02-23-2016, 11:06 PM
  2. Compare Two excel workbooks with unequal rows
    By Tanumoy86 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2014, 02:31 AM
  3. VBA Code to Compare Two Worksheets with unequal no of Rows
    By mishrav98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2013, 08:18 AM
  4. [SOLVED] Copmaring two lists and extracting all unequal rows
    By nivoe in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-16-2012, 07:42 AM
  5. How to Match and fill two lists of unequal length
    By artaxerxes in forum Excel General
    Replies: 6
    Last Post: 01-24-2012, 04:21 PM
  6. Repeat Transpose Unequal Rows
    By kirky in forum Excel General
    Replies: 3
    Last Post: 10-24-2010, 07:53 AM
  7. Replies: 3
    Last Post: 06-15-2006, 01:25 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