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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Highlight All Excel Formula Cells Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done:1.Select all the cells in your Excel worksheet by clicking on the top left hand corn...
Use Excel Goal Seek To Find The Formula Result You... If you have a formula and want to show a specific result, but you do not know what input values to change within the formula, then Excel's Goal Seek feature is the one for you.Imagine you are calculating the payment terms on a loan.Your PMT formula gives you an amount of ...
Top Excel Data Cleansing Techniques Data cleansing is an important activity within Excel and one that we find ourselves doing day in day out, sometimes without even knowing it.So what is data cleansing?In the words of Oz du Soleil, Excel MVP, it is like "Hercules being sent out to capture the three-he...
Go To Blanks The Go To Special tool within Excel is a must for any serious Excel user as it has an array of useful spreadsheet formatting and clean up tools.One that I use all the time is the Go To Special > Blanks.  This allows you to delete multiple blank rows/column within seconds. ...