However, this might not always give you an accurate average, which is where functions like GEOMEAN and HARMEAN come in. The ...

REGEX is a smarter version of Excel's FIND function, which works well for basic lookups. However, REGEX handles more complex ...

Suzanne is a content marketer, writer, and fact-checker. She holds a Bachelor of Science in Finance degree from Bridgewater State University and helps develop content strategies. Learn about our ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. David Kindness is a Certified Public Accountant ...

This database originally covered cases from 1982 to 2012 and has since been updated and expanded numerous times. For analysis and context on this data—including how we built the database, and a change ...