Please help, i have thousands of numbers, not in any particular order and I am needing to offset what can offset, how can i Isolate the numbers that offset? Please help
Please help, i have thousands of numbers, not in any particular order and I am needing to offset what can offset, how can i Isolate the numbers that offset? Please help
Wayyyy too little information. Please read the yellow banner (top) about sample sheets and act on its guidelines.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
I have column of numbers of around 11k rows, a portion of the given numbers offset and net off to zero, they are in no order. For example,
102.43
103.40
77.27
29.82
124.36
29.54
39.09
27.14
6.15
89.54
114.09
45.45
48.76
12.76
20.09
22.18
4.09
-102.43
-103.4
-77.27
-29.82
-124.36
-29.54
-39.09
-27.14
-6.15
-89.54
The total I need to be left is 267.42, is it possible to isolate the positive and negative number that net off to zero? e.g. 103.40 & -103.40.
I would be so very grateful for any help
Not an Excel file as requested, but it is clear now!
=SUMIF(A:A,">0")+SUMIF(A:A,"<0")
Thank you so very much, can the offset amounts be isolated in the rows, is this possible? e.g the orange amounts that offset to zero? there is no order to the data
102.43
103.4
77.27
29.82
124.36
29.54
39.09
27.14
6.15
89.54
114.09
45.45
48.76
12.76
20.09
22.18
4.09
-102.43
-103.4
-77.27
-29.82
-124.36
-29.54
-39.09
-27.14
-6.15
-89.54
No, not quite... since they are "not in any particular order". It took a while to come up with something that covered:
two +ve numbers at the same value and only 1 -ve number
two +ve numbers at teh same value and 2 -ve numbers.
This (monstrous) Conditional Formatting formula does that.
Formula:Please Login or Register to view this content.
See file. Unshaded cells have no match.
Thank you so very much, grateful appreciation for your help, very thankful to learn and see the work of such brilliant excel minds.
Thank you again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks