Split cell into arrays and compare them to cells in separate columns

[f00dFights]

Im working on a small project and im having trouble going about implementing this.

Im trying to create a function which scans a column (job-trav-seq) and splits the values in each cell within a given range. It then compares these values to comparable cells in separate columns (so for instance job-trav-seq would have a cell 58546-05-10; this function would remove the dashes and compare the 58546 to job number, 05 to traveller ID and 07 to sequence No.

If there is a match then the loop should carry to the next cell until the process is complete, i as thinking of using range.find but the trouble im having is how to go about implementing it

any help would be most appreciated

 

[mumps]

This is what I got when I ran the macro. The results are in column D.

foodFights.xlsm
	A	B	C	D	E	F	G
1	Job-trav-seq	Job No	Traveller	OpSeq	CompletedTask	currOp	Operation
2	12345-0-10	12345	0	* 10	0	1	random job 1
3	23456-0-10	23456	0	* 10	0	1	random job 2
4	46533-1-10	46533	1	10	1	0	random job 3
5	46533-1-20	46533	1	20	0	1	random job 3
6	46533-1-30	46533	1	30	0	0	random job 3
7	46533-1-40	46533	1	40	0	0	random job 3
8	46533-1-50	46533	1	* 50	0	1	random job 3
9	53154-1-10	53154	1	* 10	1	0	random job 4
10	53167-1-10	53167	1	10	1	0	random job 5
11	53167-1-20	53167	1	20	1	0	random job 5
12	53167-2-30	53167	2	30	1	0	random job 5
13	53167-2-40	53167	2	* 40	0	1	random job 5
14	53194-4-10	53154	2	10	1	0	random job 6
15	53194-4-20	53154	2	20	1	0	random job 6
16	53194-4-30	53154	2	30	1	0	random job 6
17	53194-4-40	53154	4	* 40	0	1	random job 6
18	61652-4-10	47652	4	10	1	0	random job 7
19	61653-4-10	48453	4	10	1	0	random job 8
20	51734-8-10	51734	8	* 10	1	0	random job 9
21	55634-8-10	55634	8	* 10	1	0	random job 10
22	58456-8-10	58456	8	* 10	1	0	random job 11
23	64845-10-10	64845	10	10	1	0	random job 12
24	64845-10-20	64845	20	* 20	0	1	random job 12
25	74561-10-10	74561	10	10	1	0	random job 13
26	74561-10-20	74561	10	* 20	0	1	random job 13
27	83634-11-10	83634	11	* 10	0	1	random job 14
28	92456-11-10	92456	11	* 10	0	1	random job 15
Sheet1 (3)

 

[f00dFights]

This is what I got when I ran the macro. The results are in column D.

foodFights.xlsm
	A	B	C	D	E	F	G
1	Job-trav-seq	Job No	Traveller	OpSeq	CompletedTask	currOp	Operation
2	12345-0-10	12345	0	* 10	0	1	random job 1
3	23456-0-10	23456	0	* 10	0	1	random job 2
4	46533-1-10	46533	1	10	1	0	random job 3
5	46533-1-20	46533	1	20	0	1	random job 3
6	46533-1-30	46533	1	30	0	0	random job 3
7	46533-1-40	46533	1	40	0	0	random job 3
8	46533-1-50	46533	1	* 50	0	1	random job 3
9	53154-1-10	53154	1	* 10	1	0	random job 4
10	53167-1-10	53167	1	10	1	0	random job 5
11	53167-1-20	53167	1	20	1	0	random job 5
12	53167-2-30	53167	2	30	1	0	random job 5
13	53167-2-40	53167	2	* 40	0	1	random job 5
14	53194-4-10	53154	2	10	1	0	random job 6
15	53194-4-20	53154	2	20	1	0	random job 6
16	53194-4-30	53154	2	30	1	0	random job 6
17	53194-4-40	53154	4	* 40	0	1	random job 6
18	61652-4-10	47652	4	10	1	0	random job 7
19	61653-4-10	48453	4	10	1	0	random job 8
20	51734-8-10	51734	8	* 10	1	0	random job 9
21	55634-8-10	55634	8	* 10	1	0	random job 10
22	58456-8-10	58456	8	* 10	1	0	random job 11
23	64845-10-10	64845	10	10	1	0	random job 12
24	64845-10-20	64845	20	* 20	0	1	random job 12
25	74561-10-10	74561	10	10	1	0	random job 13
26	74561-10-20	74561	10	* 20	0	1	random job 13
27	83634-11-10	83634	11	* 10	0	1	random job 14
28	92456-11-10	92456	11	* 10	0	1	random job 15
Sheet1 (3)

I just checked, it was the filter at the top that only showed the bottom row. Thanks you're a life saver

 

[mumps]

You are very welcome.