+ Reply to Thread
Results 1 to 6 of 6

Sorting data problem

  1. 07-09-2022, 11:45 AM #1
    rhesus3000
    rhesus3000 is offline
    Registered User
    Join Date
    07-09-2022
    Location
    greece
    MS-Off Ver
    2016
    Posts
    5

    Sorting data problem

    Hello community.
    I am here because i am desperate to find an answer.
    I have some data....in each column, numbers have to be sorted in ascending order, independently one column from the other..

    The problem is a have 1600 columns to sort, and i cant find a solution to make it possible.
    Please help me.
    Attached Files Attached Files
    Last edited by rhesus3000; 07-09-2022 at 12:21 PM.
    Reply With QuoteRegister To Reply
  2. 07-09-2022, 11:57 AM #2
    JohnTopley
    JohnTopley is offline
    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
    30,838

    Re: Sorting data problem

    Please yellow banner on how to attach a sample workbook: it suggests a VBA solution which will "loop" through the columns and sort each one indivdually.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 07-09-2022, 12:25 PM #3
    JohnTopley
    JohnTopley is offline
    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
    30,838

    Re: Sorting data problem 

    Please Login or Register  to view this content.
    Data starts in column A
    Attached Files Attached Files
    Last edited by JohnTopley; 07-09-2022 at 12:32 PM.
    Reply With QuoteRegister To Reply
  4. 07-09-2022, 12:45 PM #4
    rhesus3000
    rhesus3000 is offline
    Registered User
    Join Date
    07-09-2022
    Location
    greece
    MS-Off Ver
    2016
    Posts
    5

    Re: Sorting data problem

    YEAAAAH!!! PERFECT!!!saved me!!
    Reply With QuoteRegister To Reply
  5. 07-09-2022, 01:49 PM #5
    Czeslaw
    Czeslaw is online now
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,417

    Re: Sorting data problem

    Power Query
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-10-2022, 12:52 AM #6
    JohnTopley
    JohnTopley is offline
    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
    30,838

    Re: Sorting data problem

    Please mark as SOLVED: see "Thread Tools" at top of page.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with sorting data - Please help!
    By JimmyOS in forum Excel General
    Replies: 10
    Last Post: 03-09-2014, 02:55 PM
  2. Excel 2008 : sorting data problem
    By magsyoung in forum Excel General
    Replies: 3
    Last Post: 07-15-2010, 03:02 PM
  3. Data sorting problem
    By antesamegutt in forum Excel General
    Replies: 2
    Last Post: 09-29-2009, 11:23 AM
  4. Sorting Data Problem
    By nward in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-23-2008, 07:09 AM
  5. Problem Sorting Data
    By Alhazred in forum Excel General
    Replies: 11
    Last Post: 03-10-2008, 02:43 PM
  6. [SOLVED] Sorting problem in Chinese data
    By Tony in forum Excel General
    Replies: 0
    Last Post: 05-11-2006, 09:15 PM
  7. Problem with Sorting Data
    By reggiebu in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 05:05 PM
  8. data sorting problem
    By Pong in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1