excel tips & tricks

Excel

How to Count the number of unique values in a list in excel

How to Count the number of unique values in a list in excel Let’s consider we have a long list of duplicate values in a range and our objective is to count only the unique occurrences of each value. Though this can be a very common requirement in many Read more…

By Shoki Singh, 2 years2 years ago

Excel

Trick of split first, middle and last name in excel

How To Split Full Name To First, Middle And Last Name In Excel with the help of single formula ? You can use the mid function, substitute function,rept function and trim function to spit a full name to the first, middle and last name with following steps: step 1. suppose Read more…

By Shoki Singh, 2 years2 years ago