Sarah Schlott
  • Home
  • Contact
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu

Tag Archive for: DataIntegrity

The Most Dangerous “Modern” Excel Formula: =UNIQUE()

October 28, 2025/by Sarah Schlott

It looks clean.Effortless.No helper columns.No visible mess. That’s the problem. We’ve all been told that modern Excel formulas are smarter — that dynamic arrays make reporting faster, cleaner, more “automated.”But some automation hides danger better than any manual error ever could. And nothing proves that more than =UNIQUE(). Why =UNIQUE() Can Quietly Wreck Your Model […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/10/pexels-pavel-danilyuk-7868972-1-modified-1.jpg 801 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-10-28 09:33:522025-10-28 09:33:52The Most Dangerous “Modern” Excel Formula: =UNIQUE()

Latest Posts

  • The Budget Was Approved Long Before the Meeting
  • 8 Financial Mistakes Women in Their 40s Make—and How to Fix Them (2026 Guide)
  • Jobless Claims Fell Below 200,000
  • The Most Dangerous “Modern” Excel Formula: =UNIQUE()
  • The Most Dangerous Excel Formula in Finance
  • The Quiet Revolution: AI in FP&A 2025
  • I Didn’t Choose the Spreadsheet Life — The Spreadsheet Life Chose Me
  • The night before our board meeting, the ARR report didn’t tie out.
  • We rebuilt our churn model after it lied to us — in front of the board.
  • Some days being a SaaS CFO feels like air traffic control — but every plane is on fire.
© Copyright - Sarah Schlott
Scroll to top Scroll to top Scroll to top