Excel Help Please

[Cpreston]

I have a duplicate filter running in the same sheet. Below is some data from this sheet, the codes and the amounts. The issue is if it was just duplicated once, I could divide the full subtotal and divide by 2 to get an exact figure of duplications. However as you can see from the data some codes are duplicated once and others 3 times and some 4 times. So how can I get the amount they are over the singular amount.

Also I have just noticed in the first duplicate the price is different, so somehow fom the filter, I need a subtotal then a division of the count of the codes. Any ideas how to get about this remembering it is in a filter Thanks in advance

AM015044CRBU2004 1.3097
AM015044CRBU2004 0.697
AM015068PRBU18 0.7181
AM015068PRBU18 0.7181
AM015068PRBI14 0.7181
AM015068PRBI14 0.7181
AM015068TO54CH2010 0.6169
AM015068TO54CH2010 0.6169
AM015094CRBU2004 1.8549
AM015094CRBU2004 0.6824
AM015094CRBU2004 1.3648
AM015094CRCS1002 2.0472
AM015094CRCS1002 0.6824
AM015094PRBE52 0.6824
AM015094PRBE52 0.6824
AM015094PRBU18 0.6824
AM015094PRBU18 0.6824
AM015094PRBU18 0.6824
AM015094PRMK1004 0.6824
AM015094PRMK1004 0.6824
AM015094PRMK1004 0.6824
AM015094PRMK1004 0.6824
AM015094PRAX1000 0.6824

 

[Andrzejek]

Please use PRE tag to present your data this way:

[pre]
codes amounts
AM015044CRBU2004 1.3097
AM015044CRBU2004 0.697
AM015068PRBU18 0.7181
AM015068PRBU18 0.7181
AM015068PRBI14 0.7181
AM015068PRBI14 0.7181
AM015068TO54CH2010 0.6169
AM015068TO54CH2010 0.6169
AM015094CRBU2004 1.8549
AM015094CRBU2004 0.6824
AM015094CRBU2004 1.3648
AM015094CRCS1002 2.0472
AM015094CRCS1002 0.6824
AM015094PRBE52 0.6824
AM015094PRBE52 0.6824
AM015094PRBU18 0.6824
AM015094PRBU18 0.6824
AM015094PRBU18 0.6824
AM015094PRMK1004 0.6824
AM015094PRMK1004 0.6824
AM015094PRMK1004 0.6824
AM015094PRMK1004 0.6824
AM015094PRAX1000 0.6824
[/pre]

I assume that's what you have...

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[Cpreston]

Yes sorry didn't know about pre tag, yes that how it should look

Thanks

 

[SkipVought]

Hi,

A Table on a sheet.

No headings? Every table ought to have readings to be a proper meaningful table.

How is the filter affecting the data? You never explained what the filter is doing.

How about an AVERAGE? That's the QUOTIENT of the SUM of each and the COUNT of each.

 

[Cpreston]

Sorry did not explain very well.
The sheet does have headings
I have concatenated Product and custcode together and made a column called Duplicates. I have also highlighted these in Red.
I have created a filter on ones with just the colours to get the list which starts as above. I also have a column called M3 which as the totals

So I have duplicates and M3

Duplicates M3
AM015044CRBU2004 1.3097

Any ideas please

 

[SkipVought]

You have not clearly stated your PURPOSE.

You have stated your PROCESS.

But that might not be the best process. There might be something a whole lot better if we knew what your purpose was.

As I stated before an average might work, yes?

I'd use a PivotTable.

 

[Cpreston]

Managed to get it working using Average and then another sum through a pivot table, probably was an easier route.
Thanks for the replys anyway

 

[SkipVought]

Please post your solution as other members would like to learn from you.