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!
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!
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.
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!
Using Power Query and Power Pivot, I was able to produce your expected results.
In PQ, here is the Mcode
The file is attached for your review of these steps and the Power PivotPlease Login or Register to view this content.
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
Thanks for helping!
=IF((LEN($A2)-LEN(SUBSTITUTE($A2;".";"")))=C$1;$B2;"")
this function do all what I want.
Can you, for the benefit of all, also post the excel file, where you added this formula of #5.
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?
Last edited by asojat; 05-17-2020 at 08:19 AM.
Why needs S18 = Q:\TEST\3d3\fdc32\3f3fx3 ?
That is example how folder root should look according to levels.
In which cells we find the red text?
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.
Don't have correct structure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks