Trying to Create a Macro

B

bherrick1

Could someone please help me create a macro? The type of macro I want
to create is one that shows duplicates in a column. However I want the
duplicates to also show negative values. For example if there is a
value that is 425 and -425, i want them both to show up in the macro
and be highlighted. I would appreciate it so much. I am trying to
offset credits and debits.
Thanks,
Ben
 
D

Don Guillett

here is a formula in an adjacent column that will show 2 if a match or 1 if
not. Since it is an array formula it must be entere using ctrl+shift+enter
=COUNT(IF(ABS($A$4:$A$100)=ABS(A4),$A$4:$A$100))
 
Top