Apologies for not using Xl2bb, it doesn't seem to work on my work computer. Here I have an output of power query that i hope to use in further as a metadata tagging tool. What is the most efficient way to get the 0 index for each folder group? I wanted it to display like this for ease of reading. I could make a new column and fill down the folder path, but I feel that this is more comfortable. But how do I reference the group without a formula that is going to grab the whole column?
I have:
or
Which is more efficient or is there a better way?
...
I have:
Excel Formula:
=@XLOOKUP(0,$C$3:$C5,$D$3:$D5,0,0,-1)
Excel Formula:
=INDEX(SORT(FILTER($C$3:$D$1102,$B$3:$B$1102=B4),1,1),1,2)Which is more efficient or is there a better way?
| Folder Path | 4 | 0 | C:\Export files from local folders\DATA\Input2 |
| File Name/Properties | 4 | 1 | ALAN.xlsx 3/7/2022 1:05:04 PM 64588 B |
| File Name/Properties | 4 | 2 | ANNA.xlsx 3/7/2022 1:05:04 PM 103084 B |
| File Name/Properties | 4 | 3 | ARTHUR.xlsx 3/7/2022 1:05:04 PM 25816 B |
| File Name/Properties | 4 | 4 | BANNER.xlsx 3/7/2022 1:05:04 PM 15869 B |
| Folder Path | 7 | 0 | C:\Export files from local folders\DATA\Input5 |
| File Name/Properties | 7 | 54 | 2018.xlsx 3/7/2022 1:05:07 PM 17270 B |
| File Name/Properties | 7 | 55 | 2019.xlsx 3/7/2022 1:05:07 PM 17111 B |
| File Name/Properties | 7 | 56 | 2020.xlsx 3/7/2022 1:05:07 PM 17158 B |
| Folder Path | 8 | 0 | C:\Export files from local folders\DATA\Input6 |
| File Name/Properties | 8 | 57 | BRUCE.xlsx 3/7/2022 1:05:07 PM 69937 B |
| File Name/Properties | 8 | 58 | PETER.xlsx 3/7/2022 1:05:07 PM 39039 B |
| File Name/Properties | 8 | 59 | TIM.xlsx 3/7/2022 1:05:07 PM 21047 B |
