View Single Post
 
Old 04-16-2019, 05:21 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Add a column with an ABS formula of the dollar amount, something like
=ABS(B2)
(on row 2)
Then sort primarily on phone number, secondarily by the new column, and possibly thirdly by the actual dollar amount.
The related rows should be very close to each other.
Reply With Quote