Re: Extract select group of numbers
- From: "JHL" <mg19512000@xxxxxxxxx>
- Date: Sun, 13 May 2007 20:18:04 -0400
Thank you for your response. I'm not sure what the "id" is since, I didn't
have an id nor did you give an example if I need to create one. Maybe, I
need add to my original comment. Where I gave the examples of the numbers
AFTER sorting on the absolute value, I want to to be able to extract just
these amounts from my example.
525.00
475.00
125,000.00
450,000.00
100.00
75.00
"Billy Liddel" <BillyLiddel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:863D713B-4C22-431C-B1EC-D6C75E8D6739@xxxxxxxxxxxxxxxx
With the Company ID in A1:A20, Amts in B1:B20 and with a list of Ids in
E2:E7, then
F2
=IF(SUMIF($A$2:$A$20,$E2,$B$2:$B$20)<>0,SUMIF($A$2:$A$20,$E2,$B$2:$B$20),"")
Watch the wrapping, and copy down. You'll have to change the ranges to
suite.
Regards
Peter
"JHL" wrote:
I have a large column of numbers containing both positive and negative
amounts. I created the absolute value of these numbers in a separate
column.
Sorting the absolute value indicates I have offsetting amounts in the
original number column.How can I extract only those values that are not
offset? For example,
Amt = 1,000.00
Offset = -1,000.00
Also, some of the amounts have multiples of the same number. For example
after sorting I'll have:
15,000.00
15,000.00
15,000.00
..
..
..
15,000.00
-15,000.00
-15,000.00
-15,000.00
..
..
..
-15,000.00
525.00
475.00
125,000.00
450,000.00
100.00
75.00
..
..
..
Thanks for your help.
JHL
.
- Follow-Ups:
- Re: Extract select group of numbers
- From: Billy Liddel
- Re: Extract select group of numbers
- References:
- Extract select group of numbers
- From: JHL
- RE: Extract select group of numbers
- From: Billy Liddel
- Extract select group of numbers
- Prev by Date: Re: Excell Calculations
- Next by Date: Loosing format when converting from Excel to Text..
- Previous by thread: RE: Extract select group of numbers
- Next by thread: Re: Extract select group of numbers
- Index(es):
Relevant Pages
|
