KLICK2LEARN MORE

SAS: Customize your sorting order in Proc SQL

SAS: Customize your sorting order in Proc SQL

Welcome to Klick2learnMore……   In this post we will learn how to customize sorting order of a variable in SAS.   We know that we can sort a variable in either ascending or descending order. But few times we get the requirement of sorting a variable/column in our own customized order which is neither ASCENDING nor DESCENDING…   Suppose you are creating a table using […]

Read More Leave comment

How to use Sumifs function in Excel

How to use Sumifs function in Excel

Hello and Welcome to Klick2learn…   In this post, we are about to explain SUMIFS function in MS Excel….   Lets Start….   So what is SUMIFS Function???   The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria.   For example, we can use SUMIFS function to sum the transaction amount for a (1)  particular […]

Read More 1 Comment

How to find last position of a value in range in Excel

How to find last position of a value in range in Excel

Thanks to Vijay Rawat (one of my student) who asked this question to me and inspired me to find the solution of the same. Sometimes we face a situation in excel, when we want to find the last position of a value in a range(Vertical/Horizontal any) Suppose we have data in a range from A1 to A10 like below:     In this data we […]

Read More 2 Comments

Tricks to work with Date and time in EXCEL

Tricks to work with Date and time in EXCEL

To know which month is running, use function =Month(Today()) To see the month name instead of number, use function =Text(Month(Today()),”MMMM”) This shows the month’s name in your excel language To know which year is running, use function =Year(Today()) To see the last 2 digits of the year, use function =Right(Year(today()),2) To find the day of the week for today, use function =Weekday(today()) This will give […]

Read More 3 Comments

Enjoy this blog? Please spread the word :)

RSS
Follow by Email
Facebook
Google+
http://klick2learnmore.com/
Twitter
YouTube
YouTube
LinkedIn