Author: Jiri Krecek
-
Excel – Find Top 3 Values In A Column
The Problem Here’s the problem: MAX() gives you one value. But in the real world—tracking highest equipment costs, identifying top error frequencies, finding resource hogs—you need the podium finishers, not just the gold medal. Easily Find Top Three Values in Excel Column The clean solution is literally a single command and nothing else: LARGE(). This…
-
Excel – Dynamic Named Ranges & Dropdowns
Problem Ever watch a dropdown list break because someone added a new option to row 51? Yeah, me too. And if you were handy enough to make an offline reference that dropdown menu was reading, added more values to it without updating the reference range, and the dropdown was not refreshing? Yeah, did that one…