- Go to the specific directory where files are stored.
- Select all files by CNTRL+A.
- Press Shift and Right click on files
- Select “copy as path” from right click menu
- Paste the result in file editor
Thursday, 2 December 2021
List file names in a directory by file explorer
VLOOKUP - Data Cleansing - MSExcel
=IF(ISNA(VLOOKUP($B3,G$3:G$26,1,FALSE)), "Not Present", "Present")
=IF(ISNA(VLOOKUP($D3,B$3:B$27,1,FALSE)), "Not Used", "Used")
Subscribe to:
Posts (Atom)