The Repeat Function

Using the repeat function you are able to statistically represent data in excel.

For example if you listed Clients and wanted to indicate how important they were but did not what to include actual figures

  • The formula for Repeat is =rept(character, number)
  • We will use the dollar sign to represent $1000 in sales
  • we will enter a dollar sign on our sheet

  • List the company and value of sales
  • Begin entering the formula
  • Select the dollar sign entered on your sheet
  • Ensure that you press F4 to make it an absolute reference
  • For the number divide the amount of sales by 1000

=REPT($B$2, (E2/1000))

  • Drag down the formula to calculate the number of dollar signs for each company

Youtube Video Repeat Function