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 -