+ Reply to Thread
Results 1 to 12 of 12

Sorting and connecting

  1. #1
    Registered User
    Join Date
    05-09-2020
    Location
    Split
    MS-Off Ver
    2013
    Posts
    6

    Sorting and connecting

    Hello,

    I need help, I'm doing a lot of manual work that is possible to speed up with some formul, but I don't know how.

    In attachment is simple example.


    Thanks a lot!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sorting and connecting

    c4 =VLookup(LEN(A4),$F$3:$G$5,2,1) and drag down

    After that you can filter on the level.

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-09-2020
    Location
    Split
    MS-Off Ver
    2013
    Posts
    6

    Re: Sorting and connecting

    Still have a problem.

    I don't want to use filter, I want to sort "Code" in columns by using logic of structure ("Levels").

    Update:

    I got it, check sheet 2
    Last edited by AliGW; 05-17-2020 at 05:24 AM. Reason: Please don't quote unnecessarily!

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

    Re: Sorting and connecting

    Using Power Query and Power Pivot, I was able to produce your expected results.

    In PQ, here is the Mcode

    Please Login or Register  to view this content.
    The file is attached for your review of these steps and the Power Pivot
    Attached Files Attached Files
    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

  5. #5
    Registered User
    Join Date
    05-09-2020
    Location
    Split
    MS-Off Ver
    2013
    Posts
    6

    Re: Sorting and connecting

    Thanks for helping!

    =IF((LEN($A2)-LEN(SUBSTITUTE($A2;".";"")))=C$1;$B2;"")

    this function do all what I want.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sorting and connecting

    Can you, for the benefit of all, also post the excel file, where you added this formula of #5.

  7. #7
    Registered User
    Join Date
    05-09-2020
    Location
    Split
    MS-Off Ver
    2013
    Posts
    6

    Re: Sorting and connecting

    Sure, in attachment
    Is there code how to copy file (pdf-s) from one folder, in structure of folders? (any guid)


    Another question in excel example, how to create paths from structure?
    Attached Files Attached Files
    Last edited by asojat; 05-17-2020 at 08:19 AM.

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sorting and connecting

    Why needs S18 = Q:\TEST\3d3\fdc32\3f3fx3 ?

  9. #9
    Registered User
    Join Date
    05-09-2020
    Location
    Split
    MS-Off Ver
    2013
    Posts
    6

    Re: Sorting and connecting

    That is example how folder root should look according to levels.

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sorting and connecting

    In which cells we find the red text?

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sorting and connecting

    With a VLookup table.

    W1:Y3 =

    1 3d3
    1.5 fx21
    1.5.5 3d3\fdc32



    T1 = Q\test\

    T4=$T$1&VLookup(Left(A4,5),$W$1:$X$3,2,1)&"\"&Iferror(Indirect(Adress(Row(),Match($B4,D4:R4,0)+3)),"") and drag down.

    See the attached file.
    Last edited by oeldere; 05-17-2020 at 09:45 AM.

  12. #12
    Registered User
    Join Date
    05-09-2020
    Location
    Split
    MS-Off Ver
    2013
    Posts
    6

    Re: Sorting and connecting

    Don't have correct structure.

+ 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. Replies: 8
    Last Post: 01-16-2015, 07:21 AM
  2. Sorting & Connecting with formula
    By Sabini in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2014, 03:53 PM
  3. Connecting with SQL through VBA
    By excelhelp20817 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2014, 10:04 PM
  4. Sorting & Connecting with formula (excel 2013)
    By Sabini in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2014, 10:51 AM
  5. Connecting to TFS
    By Osiris00001 in forum Excel General
    Replies: 1
    Last Post: 07-17-2012, 05:19 AM
  6. VBA for connecting to C++
    By Carnifex930 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2011, 03:14 PM
  7. [SOLVED] Connecting to FTP
    By ben in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2006, 12:15 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