Count each unique value in a coloumn and displaye an other place

**vipin717** · 05-05-2014, 01:23 AM

Hi I am new to vba.
I want alittli help to all of you plz help me.
I want to count each unique value in coloumn 'A' and sum respectivaly in coloumn 'B' and display this in same sheet an other place with unique values.

I attached a sample sheet.
plz plz plz plz help me.

thanks alot in advance.

**AlphaFrog** · 05-05-2014, 01:35 AM

You could use the COUNTIF and SUMIF functions.

	A	B	D	E	F
1	NAME	DURATION	NAME	NO OF TIMES	SUM OF DURATION
2	Ajay	0:30	Ajay	3	1:20
3	Rahul	0:45	Rahul	2	1:30
4	Ashok	0:25	Ashok	1	0:25
5	Lei	1:00	Lei	2	2:00
6	Koko	0:50	Koko	2	1:25
7	Ajay	0:25
8	Koko	0:35
9	Lei	1:00
10	Ajay	0:25
11	Rahul	0:45

Worksheet Formulas

Cell	Formula
E2	=COUNTIF(A:A,D2)
F2	=SUMIF(A:A,D2,B:B)

**kelleytr** · 05-05-2014, 01:55 AM

There is a VBA way and a non-VBA way to do this.

Since you are in the VBA section I'm assuming you want to do this pragmatically? If not then do what Alpha Frog suggested.