Sort

[Gregp13]

I have a spreadsheet that I want to total. Some names may have single entries, others have multiple. I need total the column G's so each name has only one line. Using column A to sort .
Cheers Greg

8111111​	Smith,John	7/05/2019​			No	3​	ABCDEF	123456​
8111111​	Smith,John	14/05/2019​			No	3​	ABCDEF	123456​
8111111​	Smith,John	18/06/2019​			No	3​	ABCDEF	123456​
8222222​	Jones,Ian	5/07/2018​			No	3​	ABCDEF	123456​
8222222​	Jones,Ian	7/07/2018​			No	6​	ABCDEF	123456​
8222222​	Jones,Ian	10/07/2018​			No	3​	ABCDEF	123456​

 

[maabadi]

Welcome to MrExcel Message Board.
You want Sort based Column A. Select Range then at the Home Tab Select Sort and Filter option Dropdown, Then Select Custom Sort, Then Select column you want and sort it A-z or Z-A for Text and Smallest to largest or ... for Numbers.

 

[maabadi]

And For Total Based Column A Try This:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2	8111111	Smith,John	7/05/2019			No	3	ABCDEF	123456		9
3	8111111	Smith,John	14/05/2019			No	3	ABCDEF	123456
4	8111111	Smith,John	18/06/2019			No	3	ABCDEF	123456
5	8222222	Jones,Ian	5/07/2018			No	3	ABCDEF	123456		12
6	8222222	Jones,Ian	7/07/2018			No	6	ABCDEF	123456
7	8222222	Jones,Ian	10/07/2018			No	3	ABCDEF	123456
8
9
10
Sheet2

Cell Formulas
Range	Formula
K2:K7	K2	=IF(COUNTIF($A$2:A2,A2)=1,SUMIF($A$2:$A$7,A2,$G$2:$G$7),"")

 

[maabadi]

Or Try Red Part:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Code	Name	Date								Total		Unique List	Name	Total
2	8111111	Smith,John	7/05/2019			No	3	ABCDEF	123456		9		8111111	Smith,John	9
3	8111111	Smith,John	14/05/2019			No	3	ABCDEF	123456				8222222	Jones,Ian	12
4	8111111	Smith,John	18/06/2019			No	3	ABCDEF	123456
5	8222222	Jones,Ian	5/07/2018			No	3	ABCDEF	123456		12
6	8222222	Jones,Ian	7/07/2018			No	6	ABCDEF	123456
7	8222222	Jones,Ian	10/07/2018			No	3	ABCDEF	123456
8
9
Sheet2

Cell Formulas
Range	Formula
N2:N7	N2	=IFNA(VLOOKUP(M2,$A$2:$B$7,2,0),"")
O2:O7	O2	=IF(SUMIF($A$2:$A$7,M2,$G$2:$G$7)=0,"",SUMIF($A$2:$A$7,M2,$G$2:$G$7))
M2:M4	M2	=IFERROR(INDEX($A$2:$A$7, MATCH(0,COUNTIF($M$1:M1, $A$2:$A$7), 0)),"")
K2:K7	K2	=IF(COUNTIF($A$2:A2,A2)=1,SUMIF($A$2:$A$7,A2,$G$2:$G$7),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Gregp13]

And For Total Based Column A Try This:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2	8111111	Smith,John	7/05/2019			No	3	ABCDEF	123456		9
3	8111111	Smith,John	14/05/2019			No	3	ABCDEF	123456
4	8111111	Smith,John	18/06/2019			No	3	ABCDEF	123456
5	8222222	Jones,Ian	5/07/2018			No	3	ABCDEF	123456		12
6	8222222	Jones,Ian	7/07/2018			No	6	ABCDEF	123456
7	8222222	Jones,Ian	10/07/2018			No	3	ABCDEF	123456
8
9
10
Sheet2

Cell Formulas
Range	Formula
K2:K7	K2	=IF(COUNTIF($A$2:A2,A2)=1,SUMIF($A$2:$A$7,A2,$G$2:$G$7),"")

Thanks very much for that.

Or Try Red Part:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Code	Name	Date								Total		Unique List	Name	Total
2	8111111	Smith,John	7/05/2019			No	3	ABCDEF	123456		9		8111111	Smith,John	9
3	8111111	Smith,John	14/05/2019			No	3	ABCDEF	123456				8222222	Jones,Ian	12
4	8111111	Smith,John	18/06/2019			No	3	ABCDEF	123456
5	8222222	Jones,Ian	5/07/2018			No	3	ABCDEF	123456		12
6	8222222	Jones,Ian	7/07/2018			No	6	ABCDEF	123456
7	8222222	Jones,Ian	10/07/2018			No	3	ABCDEF	123456
8
9
Sheet2

Cell Formulas
Range	Formula
N2:N7	N2	=IFNA(VLOOKUP(M2,$A$2:$B$7,2,0),"")
O2:O7	O2	=IF(SUMIF($A$2:$A$7,M2,$G$2:$G$7)=0,"",SUMIF($A$2:$A$7,M2,$G$2:$G$7))
M2:M4	M2	=IFERROR(INDEX($A$2:$A$7, MATCH(0,COUNTIF($M$1:M1, $A$2:$A$7), 0)),"")
K2:K7	K2	=IF(COUNTIF($A$2:A2,A2)=1,SUMIF($A$2:$A$7,A2,$G$2:$G$7),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Hello Maabadi, do I just use the formula in red< or all 3?

 

[maabadi]

Red Part has 3 Column. Column 1 & 2 for Extract unique values. and column 3 for sum based unique values. Then you need all 3.