CA Rishabh Pugalia (ExcelNext)
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 CAClubindia.com – 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 ISCANotes.com
• Request for in-house Corporate Training for staff members – Click Here
CAclubindia
