Month: July 2015

Approach to find last row or column using VB script in Excel?

July 28, 2015

We are sharing these techniques so that we can work with dynamic set of data in an Excel. Do follow us for more learning’s Fb,G+,Twitter.Technique 1:- Using UsedRange property:- This approach is frequently implemented and one of our favorite. But sometime we have seen that incase some formatting is present in the sheet, it points till the last […]

Read More

SQL Interview Questions (Set-1)

July 14, 2015

This is our first set of SQL interview Questions. Prepare well and crack your dream job. It is said,“Fall seven times, stand up eight.”(Japanese proverb), so work hard to achieve heights. Work Hard Follow us on Facebook for more updates and learning!!! What are various types of SQL statements? What is the difference between Truncate, Drop and […]

Read More

How to randomize rows of data in a Excel?

July 10, 2015

Problem:- How to randomize the given set of data in an Excel?Solution: – We would try to shuffle the rows of data in a given excel. We would try it manually first followed by code written in Vb-script.Manual Approach:- Step1:- Add column(say Random) in the starting of the excelStep2:- Apply formula to the first cell (=Rand ()) […]

Read More