Matching numbers in a column

  • Thread starter Thread starter Craig Stone
  • Start date Start date
C

Craig Stone

I have a column of 267 numbers (imported from QuickBooks with amounts of
cash received and cash deposited in the bank) represented by positive and
negative numbers. Theoretically for each positive number there should be a
corresponding negative. Of course they don't balance, therefore I would like
to specifically match each number (all the positives with all the negatives)
to determine which amounts don't have an offset to analyze. I have sorted
all the numbers in ascending order and can manually check off each one but
I'd like to automate this process. Is it possible?
Thanks...jcs
 
Craig

You could use a helper column with =ABS(A1) in it and fill it down.
If you sort on this column, it will put the amounts in order, irrespective
of whether they are positive or negative.

Andy.
 
Back
Top