Data Sorting

[niting]

Hie forum,


I have some date coming from SAP in this format-:


Col A COl B COl C

01-04-2010 Narration 4444

03-04-2010 Narration 5555

05-05-2010 Narration -4444


Now the point is that the positive entry will be knocked off by the negative entry. But the entries happen at different dates. The problem I have is that while reconciling, I have to manually check for positive and negative entry. Is there a formula, method or anything, wherein, if the number is same, the positive and negative entries appear in column one below the other.


I would greatly appreciate any suggestions/help.


Thanks

Nitin

 

[Luke M]

Helper column D formula:

=ABS(C2)


Copy down as needed, then sort on D to group same numbers together.