count duplicate entries

[cryline]

I have a column of job numbers (A) and associated info in other columns related to the job number identifier. Sometimes a job will have a number of tasks so the job number will appear multiple times.
I'm looking for a formula that will count the number of duplicate job numbers when they occur and insert this figure into an adjacent column - possibly against the first instance so I can then delete the duplicate job number rows.

Any suggestions?

Thanks in advance

Adrian

 

[bschwartz]

Do either of these two options work for you?

Excel 2010
	A	B	C
1	Job Number	Total Dups after 1st	Occurrence # After 1st
2	8	3	0
3	9	2	0
4	9	2	1
5	3	2	0
6	10	2	0
7	3	2	1
8	3	2	2
9	4	1	0
10	5	1	0
11	5	1	1
12	10	2	1
13	8	3	1
14	2	2	0
15	7	0	0
16	9	2	2
17	2	2	1
18	1	0	0
19	2	2	2
20	4	1	1
21	10	2	2
22	6	0	0
23	8	3	2
24	8	3	3
Jobs

Cell Formulas
Range	Formula
B2	=COUNTIF($A$2:$A$24,A2)-1
C2	=COUNTIF(A$2:A2,A2)-1

 

[cryline]

So simple... I was really overcomplicating it with IF and MATCH formulas. Thasks!

 

[bschwartz]

You're welcome. Thanks for providing feedback.