hmmm.....
It appears that since i use a formula to pul these numbers from another
sheet the filter option isnt working

"muddan madhu" wrote:

go to data | filter | advance filter | choose copy to another location
| List range = $A:$A | copy to : $C$1 | check unque records only | ok



On Jan 28, 1:21 pm, Lost wrote:
thanx, works great. I got one more for ya. How do i eliminate double lots
being pulled over from column A to column C so i get this?
A B c
d
123456789 300 123456789 600
1234567890 1000 1234567890 3000

0 1508430
324
0
123456789 300
1234567890 1000
0
0
1508430 324
1234567890 1000

And not....
A B c
d
123456789 300 123456789 600
1234567890 1000 1234567890 3000

0 1508430
324
0 123456789
600
123456789 300 1234567890 3000
1234567890 1000 1508430 324
0
0
1508430 324
1234567890 1000



"muddan madhu" wrote:
In Cell D1 put this formula and drag it down

=SUMIF(A$1:A$10,$C1,B$1:B$10)

On Jan 28, 10:57 am, Lost wrote:
Help please....
Ok I need to figure out how to get column A to condense to column C and the
totals from Column B to sum up in column D. Column A&B is 66 cells long.
Sorry if this is to vauge, if need more info post.

A B c
d
123456789 300 123456789 600
1234567890 1000 1234567890 3000
0 1508430 324
0
123456789 300
1234567890 1000
0
0
1508430 324
1234567890 1000- Hide quoted text -

- Show quoted text -