If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find & Select > Go To Special > Row Differences.

Once the cells have been identified, you can color them in and then filter to see each transaction.

DOWNLOAD WORKBOOK

Row Differences

Helpful Resource:

MOTH-excel_expert470x63

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Quick Access Toolbar The Quick Access Toolbar (QAT) is located at the top left hand corner of the ribbon and has the most commonly used commands, like the Save, Undo and Redo.  The QAT is unique to each user´s workbook settings. You can move the QAT below or above the ribbon by right clicking on t...
Consolidate in Excel with the CONSOLIDATE Tool The Consolidate tool in Excel is located in the Data menu and combines values from multiple ranges into one new range. You would use this feature when you have a single text column on the left and the column has many duplicate values. First you need to select a blank cell o...
Show The Percent of Column Total With Excel Pivot ... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, ...
Show The Percent of Difference From Previous Years...   I am sure that your boss has asked you to come up with a Year on Year variance report at some stage.  There are a couple of ways to get him/her an answer. One is using Formulas, but that will take time to set up and you are exposed to errors! The other method is t...