vdishub

  • Home
  • Java
  • Android
  • Ionic
  • Excel
    • Tips & tricksTips and tricks for excel category.
  • Contact Me

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, 3 years3 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, 3 years3 years ago
Categories
  • Excel (3)
  • Ionic (1)
  • Java (2)
  • Tips & tricks (2)
Recent Posts
  • Difference between Interface and Abstract class
  • Extract unique record with the help of Advanced Filter
  • complete Ionic 3 framework setup
  • Difference between final, finally and finalize
  • How to Count the number of unique values in a list in excel
Archives
  • June 2018
Archives
  • June 2018 (6)

  • About Me
  • Contact Me
Hestia | Developed by ThemeIsle