Hi there !
I am very very new to using excel.
I need to do the following :
column1 column 2
.5 * a1
.5 * *a2
.5 * a3
.5 * a3
.5 * a5
.5 * a6
.5 * a2
.5 * a1
As you can see, A3, A2 and A1 are repeated. I need to add the values in column 1 and collate to their respective values in column 2.
As a result i need to have an output in which the total of A1 should be displayed as 1 and the same for others. Please let me know if there is any formula/macro for doing this. Your help is appreciated in advance. thanks !!
i have attached a sample report..
Bookmarks