REPT IMAGE

7 WAYS TO USE EXCEL REPT FUNCTION

Crispo Mwangi | 29-Jun-17 | 5 Comments

When is the last time you used REPT function in Excel? REPT  is one of excel’s little-known, overlooked and underutilized function, yet very useful. Generally, REPT  returns a specific text string a specified number of times. =REPT(“Text”, Number of times) Here are 7 ways you can start using REPT function. ADD LEADING ZEROS CREATE INLINE […]

highlight123

Highlight a Sample In a Range or Text that contain certain Values

Crispo Mwangi | 14-Jan-17 | Leave a Comment

Learning how to use conditional formatting in excel can save you a lot of time when you need to visually highlight important information in a worksheet. At basic level, it can be used to highlight duplicates, values within certain threshold, Top or Bottom N items etc.  However, to get the full potential of conditional formatting, you […]

blogunique

COUNT UNIQUE DUPLICATE VALUES IN EXCEL

Crispo Mwangi | 30-Jul-16 | 4 Comments

COUNTIF is an excellent function to count only those cells whose  value meets a certain criteria. But as excellent as it is, it becomes a challenge to count Unique or Repeats in a range that contain duplicates. For example, Using below data count; Total number of unique customers Total Non-Repeat Customers Total Repeat customers There are 4 ways of counting […]