Excel – Remove Everything But Duplicate Rows

In Excel, we all know that, there will be a moment in which we need the opposite the people usually need on usual Excel worksheets: this is the case of searching and filtering, from a dataset, only duplicates values, removing the unique ones. Read More …

SQL Server – ANSI_Padding and Scripting from SSMS

Let’s say that you want to quickly create a table from an existing table in another database. If you are Read More …

Setup Transaction Replication in SQL Server 2012

Transaction Replication is used when DML or DDL schema changes performed on an object of one database on one SQL Read More …

Excel – Formula to check if cell contains specific string

=ISNUMBER(SEARCH(substring,text)) If you need to check if a cell contains a substring (specific text), you can do so with the Read More …

Excel – How to Sort Multiple Rows and Columns

With Microsoft Excel‘s powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically Read More …

Calculate a column only in a worksheet using macro (Excel)

Scenario How can I select a column from a cell in Excel, and then calculate this column only ? I Read More …