|
|
#2
04-16-2019, 05:21 PM
|
||||
|
||||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula Assistance for restricting the number of for analysis | gspikesr | Excel | 3 | 05-02-2016 11:28 PM |
 Need assistance with multiple IF argument formula
|
Btrrcup610 | Excel | 1 | 02-25-2016 11:14 AM |
| Assistance with Word 2010 If formula | ciresuark | Word | 1 | 03-09-2015 12:57 PM |
| Formula Help Required | OTPM | Excel | 6 | 08-31-2011 02:58 AM |
|
Formula assistance please
|
blazzercat | Excel | 2 | 07-08-2009 08:45 AM |
Windows 10 
Office 2016
Threaded Mode