Product with Criteria

Hi,

I have a two columns
1 0.5
1 0.4
1 0.2
2 0.3
2 0.2
3 0.25
3 0.2
3 0.4
3 0.2
4 0.8

What I need to do is multiply all the elements in the second column with the same first column field
i.e.
1 (0.5*0.4*0.2)
2 (0.3*0.2)
3 (...

I was wondering can I get away without writing a VBA script.

Thanks in advance.

hello axed
sorry but i don't understand, you say you have two columns, lets call them A&B, what numbers are in each column please. may be attach an example with an example of what you require
regards
Peter

Thanks. Sorry was not aware of the rule.