How to Extract the Last filename from a Folder/Subfolder?

[omairhe]

Hi, how are you?



The directory is

D:\Users\"*"\Dropbox\Sara Share\

The next folder that comes is the year
example
D:\Users\"*"\Dropbox\Sara Share\2019
D:\Users\"*"\Dropbox\Sara Share\2020
D:\Users\"*"\Dropbox\Sara Share\2021

Each of these folders will contain file/s in the format as

01-2021 (sara.ali).xlsb
02-2021 (sara.ali).xlsb
11-2021 (sara.ali).xlsb
12-2021 (sara.ali).xlsb
01-2020 (sara.ali).xlsb
02-2020 (sara.ali).xlsb


I want a formula that could check if filename ends with .xlsb then extract the complete filename with directory of the highest value only.

In this case the formula would output the following string

D:\Users\Sara Ali\Dropbox\Sara Share\2021\12-2021 (sara.ali).xlsb

I hope it would be easy for the Gurus.

Thank you.