Results 1 to 11 of 11

How to sort the types of materials from one column according to position from other column

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    Romaia
    MS-Off Ver
    sheets
    Posts
    6

    Exclamation How to sort the types of materials from one column according to position from other column

    I have in Page1, column B, 5 types of materials. In column L, I have numbered the position of each one.
    So, Position 1 to 6, is 'Plastic tube', 7 to 11 is 'Textil Tube':

    Screenshot 2021-02-24 at 11.17.52 AM.png

    I need a formula, in Page 2, to summarize all of this, that can calculate this automatically, what kind of material is in each postion .

    Like this:

    Position :
    1,2,3,4,5,6,15,16,17 - Plastic tube
    7,8,9,10,11,19,20,21,22 - Textil tube
    12,13,14 - Heat tube


    I tried a lot with IF but not a good result. Not even close...

    Anyone can help?

    Thank you
    Attached Files Attached Files
    Last edited by El3cTr0; 02-25-2021 at 03:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-14-2019, 05:24 AM
  2. Replies: 12
    Last Post: 09-08-2018, 10:34 PM
  3. [SOLVED] Button to Copy Column Range with ActiveCell position, Losing formatting after 3rd column
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-16-2018, 03:42 PM
  4. Replies: 1
    Last Post: 03-29-2018, 07:58 AM
  5. Replies: 2
    Last Post: 05-19-2015, 08:50 AM
  6. How to sort by date column, which is not always at the same position?
    By Efendi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2013, 09:06 AM
  7. Sort column containing different data types
    By pavlosbat in forum Excel General
    Replies: 1
    Last Post: 11-24-2005, 04:45 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