Write a spreadsheet formula

I want a spreadsheet formula that does this: [DESCRIBE]. My columns are [LIST]. Give the formula, how it works, and a test example. I'll check it on sample data.