LinkBack URL
About LinkBacks
Hi.
I'm searching for a solution to an accounts problem where I have one column.
That coulmn contains certain corresponding Dr & Cr numbers (1 negative & 1 Positive) that I need flagged for removal.
Help appreciated.
Colmodoc
Hi.
I'm searching for a solution to an accounts problem where I have one column.
That coulmn contains certain corresponding Dr & Cr numbers (1 negative & 1 Positive) that I need flagged for removal.
Help appreciated.
Colmodoc
Use a helper column, if your positive and negative numbers are in column A, put this in B1 and copy down
=ABS(A1) then sort your data based on this column
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Very good. Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks