Mr Excel & excelisfun Trick 156: Find Unmatched Positive & Negative Numbers In A Column

Описание к видео Mr Excel & excelisfun Trick 156: Find Unmatched Positive & Negative Numbers In A Column

Download Files: https://people.highline.edu/mgirvin/Y...

Download workbook: http://people.highline.edu/mgirvin/Ex...
See Mr Excel and excelisfun use VBA and formulas to Find Unmatched Positive and Negative Numbers In A Column. Often times used for finding unmatched Debits and Credits
1. (00:14 min) VBA
2. (06:52 min) Two COUNTIF functions in a logical formula,

Комментарии

Информация по комментариям в разработке