+ Reply to Thread
Results 1 to 4 of 4

Using Concat function - Not Sorting properly

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    9

    Using Concat function - Not Sorting properly

    So my job requires me to take a spreadsheet and sort its items by kit version. So, 2500 rows (stores) and 50 columns (items). I use concat from say M2:BJ2 and copy it down to all the rows. All the item cells within are filled with a number, some are 0 if a store does not get that item. In the end, I want to sort the concatenated column so I can determine how many like kit versions there are. This has worked flawlessly in the past, but recently I am having issues with the larger sheets. The concatenated column does not sort properly, so my formula in the column next to it gives me 429 kit versions, but if delete all the duplicate values in the concatenated column, i get 122 unique values. Not sure what the issue is, but hoping someone may be able to help. Thank you!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,178

    Re: Using Concat function - Not Sorting properly

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    02-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Using Concat function - Not Sorting properly

    I have attached a file names DataSample. Hope this helps, thank you for looking into this!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Using Concat function - Not Sorting properly

    Any ideas on this one??

+ 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] VBA Not Sorting Properly
    By phelbin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2015, 12:56 PM
  2. Replies: 5
    Last Post: 01-30-2015, 10:45 AM
  3. Sorting A-Z not working properly
    By AKM1 in forum Excel General
    Replies: 1
    Last Post: 09-03-2013, 10:29 AM
  4. VBA function help. Concat cells based on parallel value. Function Included!
    By xsa in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2013, 10:18 AM
  5. Report not sorting properly
    By nzkazza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2012, 10:46 PM
  6. [SOLVED] sorting is not properly done on folders
    By joe41 in forum Word Formatting & General
    Replies: 1
    Last Post: 03-20-2009, 07:40 AM
  7. concat function
    By okl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2008, 10:00 AM

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