Sunday, January 31, 2016

Excel Useful Formula #1

1. Find the repeated contents: =if(countif(A:A,A2)>1, "Repeated content", "")


2. Formula: =TRUNC((DAYS360(D1,today(), FALSE))/360, 0)

D1: is your target cell for input date of birth
today(): is the formula to return the date of today

3. Ranking: =rank(K2, K$2:K$56) ranking of 55 students results

4. Grading: =if(K2>=85, "A", If(K2>=74, "B", IF (K2>=60, "Pass", "Fail")))

5. Count with condition:

=countif(B2:B56, "80")

=countif(B2:B56, ">=80")

Friday, January 1, 2016

Sorting in OSX

In OSX, sorting and arranged by is different.


  • View > Arrange By > None (^⌘0)
  • Hold Option, View > Sort By > Name (^⌥⌘1)



Try the above commands, you will see the difference!