How to Use repeat (REPT) function in Excel

Mar 13, 2010 06:45 AM
Article cover image

There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better. Next to one of the cells, type in "=REPT(" which is the repeat function. A popup should say "=REPT(text, numbertimes)". For "text", type in *** or anything, really. For "numbertimes", type in the cell number you are typing next to. Click enter. The *** or whatever you typed in will be repeated the number of times that is in the cell number you entered in "numbertimes". Drag that cell down all the way to the bottom of the chart. All of the sales (or whatever numbers you are comparing) will be represented in a bar chart-like format. This function can be very helpful when comparing different sets of data.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!