Hi all-
First post here, hope it finds all of you well!
I am trying to match the positive and negatives that net to $0 in my workbook w/ over 3,000 rows. I saw there's a solving formula for this in another thread, with this formula:
=AND(K1<>"",SUMPRODUCT(--(ABS($D$2:$D$1000)=ABS(K1))))
This was trying to match positive to negative in two different columns. All of my data is in one column, so I replaced all the "K" and "D" to my column number. But it does not return anything....
Can someone please help? Sorry if this is a repeating question. Thank you all so much!
Bookmarks