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 …

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 on Circular References

What is a Circular Reference & why use them? A circular reference is created when you refer to same cell Read More …

Show Formulas In Excel 2010 Cells

Excel 2010 has built-in option to deal with the data cell according to the user’s need. Sometime for making audience Read More …

Change the row color based on a cell’s value (Excel)

Say, you have a table of your company orders like this: You may want to shade the rows in different Read More …