+ Reply to Thread
Results 1 to 8 of 8

Request = sort the 10 columns into the 4 groups

  1. 10-18-2017, 06:24 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Request = sort the 10 columns into the 4 groups

    Request = sort the 10 columns into the 4 groups
    Group of 01 to 25 = 1 26 to 50 = 2 51 to 75 = 3 76 to 00 = 4
    http://www.mediafire.com/file/461ibh..._divisoes.xlsx
    Reply With QuoteRegister To Reply
  2. 10-18-2017, 06:26 AM #2
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Request = sort the 10 columns into the 4 groups

    sorry , corret= https://www.excelforum.com/attachmen...1&d=1508322357
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 10-18-2017, 07:08 AM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Request = sort the 10 columns into the 4 groups

    hello please?
    Reply With QuoteRegister To Reply
  4. 10-18-2017, 07:41 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Request = sort the 10 columns into the 4 groups

    I have no idea what you want!! Please explain.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  5. 10-19-2017, 02:11 PM #5
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Request = sort the 10 columns into the 4 groups

    Hello !!! I, explain = we have numbers from 00 to 99 was divided into 4 blocks
    1,2,3,4 classify each column in the color of two numbers
    * Example
    * 01 15 is within 01 to 25 or is 1.1
    Reply With QuoteRegister To Reply
  6. 10-20-2017, 07:14 PM #6
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Request = sort the 10 columns into the 4 groups

    If I understand correctly then the following formula should yield the desired results:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  7. 10-20-2017, 07:27 PM #7
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Request = sort the 10 columns into the 4 groups

    ok, JETEMC, PERFECT, CONGLULATIONS, thank you!!!
    Reply With QuoteRegister To Reply
  8. 10-20-2017, 08:00 PM #8
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Request = sort the 10 columns into the 4 groups

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
    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. Macro to read excel files and sort data according to groups and sub groups in one workbook
    By Afandi1992 in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 01-15-2016, 03:38 AM
  2. trying to sort groups
    By tigger66 in forum Excel General
    Replies: 4
    Last Post: 10-20-2015, 04:43 AM
  3. Yet another graph over time request (sort of)
    By adamuk2013 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-26-2013, 01:28 PM
  4. [SOLVED] Copy and sort request from wsWB1 to wsWB2
    By MBCMDR in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-20-2012, 04:24 AM
  5. How can you sort groups?
    By Marsupial in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-30-2011, 01:43 PM
  6. Pivot table alphabetic sort request
    By Stu100 in forum Excel General
    Replies: 2
    Last Post: 03-09-2010, 09:37 AM
  7. Sort by groups
    By bobbismal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2007, 10:40 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