Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
TRIMRANGE
Welcome to this post, where we’ll dive into Excel’s TRIMRANGE function and its companion Trim Refs operators. These recent additions make working with dynamic ranges and calculated columns more efficient and intuitive. Note: as of the time of this post, these are in limited release and not all versions of Excel have them. For availability…
Read More