Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Case Study 1:

Visualize ratings of employees

Application Areas:

Feedback/Performance Ratings

Techniques required for Solution: 

Formula =REPT()

[Picture 1]: =REPT() formula repeats specified character(s) the no. of times you specify

Case Study 2: Add Zeroes as pre-fix to raw codes of varying lengths so to make all 5-digit code

Application Areas: Data migration, Data cleaning

Techniques required for Solution:  Formula =REPT(), &, =LEN()

[Picture 1]: Input vs. Target Output

[Picture 2]: Find no. of zeroes to be added using the logic =5-LEN (length of existing codes)

[Picture 3]: Repeat zeroes the no. of times as specified by previous step and concatenate (join) using “&” to the raw codes (input)

• CA. Rishabh Pugalia’s other popular articles on Excel tricks at – Click Here

• Subscribe to his Online Training Program at CAclubindia. Click Here to watch his sample training videos on VLOOKUP(), Thermometer Charts, What IF Analysis buttons, Time-saver tricks.

• His notes on CA Final - ISCA is available at

 Request for in-house Corporate Training for staff members – Click Here


8 Likes   135 Shares   41256 Views


Popular Articles

Follow taxation Exam20 Book Book

CCI Articles

submit article

Stay updated with latest Articles!