DESCRIPTION
See how to Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula.
WORKBOOKS
Download “Excel Magic Trick 1391-1400” Excel-Magic-Trick-1391-1400.zip – Downloaded 102 times – 3 MB
Excel Is Fun
Excel Magic Trick 1227
DESCRIPTION Conditional Format: Min, Max & Min Value Greater Than Zero Learn how to: (00:12) Problem Introduction (00:38) Conditionally Format the Maximum value in a set of numbers with built in Top 1 Rule (01:32) [Read More >>>]
Tricks & Tips
Display Day Name From A Date
If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how [Read More >>>]
Excel Is Fun
Excel Magic Trick 1145
Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards [Read More >>>]
Leave a Reply
You must be logged in to post a comment.