Calculate and Report Median on Multiple Files

[twowlz]

I have over 200 excel files that have the same headers but different number of records for each. I need to calculate the median for column F for each file and then report that median (on one file if possible) for each file using the filename of said file. Is this something someone can help with? I would be forever grateful to be able to automate this

 

[barry houdini]

I have over 200 excel files

Hello twolz, welcome to Mr Excel

When you say 200 "files" do you mean 200 different workbooks or 200 worksheets in a single workbook?

 

[twowlz]

Thank you for asking. It’s 200 different workbooks—not worksheets.