LAST AND UNIQUE VALUE

No Comments
Hey Guys!!!

Here's are some questions related to data and must read this post if all your answers will take to next question :-

  • Have you ever require to get filter Last and unique values from a data ? 
  • If yes what would you like to do then ? 
  • Do you do it manually ? 
  • But if it is in whole data and regular job then what would you do?

Here's a example in which you can find last and unique value from a data table using simple formulas and take decision based upon it. See how it is being done:-





You can learn the formulas used and described in the picture with there details and limitation by clicking on the following :-

  1. IF
  2. COUNTIF
  3. ""

SUM FOR FIRST AND UNIQUE VALUE

1 comment
Hey Guys!!!

Here's are some questions related to data and must read this post if all your answers will take to next question :-

  • Have you ever require to get filter first and unique values from a data ? 
  • If yes have you ever need to find total for those value ?
  • If yes what would you like to do then ? 
  • Do you do it manually ? 
  • But if it is in whole data and regular job then what would you do?

Here's a example in which you can easily find sum for first and unique value from a data table using simple formulas. See how it is being done:-

You can learn the formulas used and described in the picture with there details and limitation by clicking on the following :-
  1. MATCH
  2. IF
  3. SUMIF
  4. ""

FIRST AND UNIQUE VALUE

No Comments

Hey Guys!!!

Here's are some questions related to data and must read this post if all your answers will take to next question :-

  • Have you ever require to get filter first and unique values from a data ? 
  • If yes what would you like to do then ? 
  • Do you do it manually ? 
  • But if it is in whole data and regular job then what would you do?



Here's a example in which you can find first and unique value from a data table using simple formulas and take decision based upon it. See how it is being done:-


You can learn the formulas used and described in the picture with there details and limitation by clicking on the following :-


  1. MATCH
  2. IF
  3. ""

BREAK and COMBINE Name's

No Comments
Hey Guys!!!

Perhaps some time you find that you have to break name into Prefix, First Name, Middle Name and Last Name or you have to combine all these to get Name.If it is one time then you can do it manually. But if it is in whole data then what would you do?

Here's a example in which you can break or combine a name fields using formulas. See how it is being done:-



CONVERT DATE FORMAT

No Comments
Hey Guys!!!

Perhaps some time you find that you have to convert the date format as shown below:-

24/02/2018  >>>>>>>  24th February, 2018. 

and If it is one time then you can do it manually. But if it is in whole data then what would you do?

Here's a example in which you can change it using formulas. See how it is being done


Amazon

Is this article helpful to you?