LAMBDA lets you turn repeated Excel logic into reusable functions that update automatically across your entire workbook.

I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far I ...