REPT or repeat can save time when typing a large string of numbers.
Example:
Rather than typing “—————————-”
use the formula =REPT(”-”,20) (formula displays “-” 20 times)
This YouTube clip shows REPT function being used to create an instant bar chart. It’s a pretty cool idea. Since the repeat function is limited to 32,767 characters, you may need to divide by 100,000 to compare customer revenue. To compare % you could multiple by 100. Watch the 1:33 minute video to see how easy REPT is to use.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare