sorting data

[fahimip]

Morning Guys

I have a table i need to sort, it consists of three columns

Company, code & quantity

The problem i have is that company names can turn up more than once
this means that i need to be able to identify the rows where the company names are the same and then lump them together,
I could also do with addiing up the codes that are repeated.

heres an example;

Company Qty code

HARRISON 1 SCR/SUPP/54
J A LTD 1 SCR/SUPP/11
FOUNDRY LTD 1 SCR/SUPP/06
2 SCR/SUPP/54
1 SCR/SUPP/54
CASTINGS LTD 1 SCR/SUPP/54
SIGMACASH LTD 4 SCR/SUPP/54
THOMAS 1 SCR/SUPP/54
1 SCR/SUPP/06
CHINA ENG CO LTD 1 SCR/SUPP/44

FOUNDRY LTD 6 SCR/SUPP/06
2 SCR/SUPP/61
16 SCR/SUPP/06
1 SCR/SUPP/06
2 SCR/SUPP/61
1 SCR/SUPP/06
CASTINGS LTD 1 SCR/SUPP/07
1 SCR/SUPP/06


I realise its all over the place, but the company name comes first followed by a quantity and code (SCR/SUPP....)

if you have any questions please let me know

i will attempt to get back to you asap


Thanks

 

[Andrew Poulsom]

If your data looks like this:

Book2
	A	B	C	D
1	HARRISON	1	SCR/SUPP/54
2	J A LTD	1	SCR/SUPP/11
3	FOUNDRY LTD	1	SCR/SUPP/06
4		2	SCR/SUPP/54
5		1	SCR/SUPP/54
6	CASTINGS LTD	1	SCR/SUPP/54
7	SIGMACASH LTD	4	SCR/SUPP/54
8	THOMAS	1	SCR/SUPP/54
9		1	SCR/SUPP/06
10	CHINA ENG CO LTD	1	SCR/SUPP/44
11	FOUNDRY LTD	6	SCR/SUPP/06
12		2	SCR/SUPP/61
13		16	SCR/SUPP/06
14		1	SCR/SUPP/06
15		2	SCR/SUPP/61
16		1	SCR/SUPP/06
17	CASTINGS LTD	1	SCR/SUPP/07
18		1	SCR/SUPP/06
Sheet1

Click the header for column A and choose Edit|Go To|Special|Blanks|OK. Type =, press the up arrow and press Ctrl+Enter to fill in the missing names. Click the header again and Copy|Paste Special Values to remove the formulas.

Now insert some suitable headers in row 1, and you can sort the list or create a pivot table from it.

 

[fahimip]

Cheers Andrew, neat trick

that worked a treat