Count.xlsx

<div>
<div class="content wysiwyg-content">
I have two columns, W and X. W is for ordered and X is for shipped. I already have conditional formatting to check the row with W and X but looking to how you count the discrepancies when they are not equal - as in zero shipped or partial shipments.<br />
Thanks in advance for any suggestions.
</div>
</div>


I have two columns, W and X. W is for ordered and X is for shipped. I already have conditional formatting to check the row with W and X but looking to how you count the discrepancies when they are not equal - as in zero shipped or partial shipments.
Thanks in advance for any suggestions.

Counting discrepancies between two columns

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.