Array question

[I2omani]

Howdy,
I am trying to make my life easier using an excel sheet to populate router se. this is the format i am looking for "Se7/0/0.12/2:1". so this is in group 7 and it is card no 12, port 2. so my the formula i am looking for will return "864-2"

I have 10 group , i am trying to find a way to write the card number and the port number from the Serial.
Group 7
1 853
2 854
.
.
12 864

can this be done

thank you in advance

 

[GlennUK]

Here's my attempt at reverse formula:

Excel Workbook
	A	B	C	D	E	F	G	H
1		Group 4	Group 5	Group 6	Group 7		initial string =	864-2
2	1	817	829	841	853
3	2	818	830	842	854		reverse ...
4	3	819	831	843	855		( starting with H1 cell )
5	4	820	832	844	856		get first part	864
6	5	821	833	845	857		get row in sheet	13
7	6	822	834	846	858		get col in sheet	5
8	7	823	835	847	859		Get group	Group 7
9	8	824	836	848	860		Make serial	Se7
10	9	825	837	849	861		Make card	12
11	10	826	838	850	862		Final result	Se7/0/0.12/2:1
12	11	827	839	851	863
13	12	828	840	852	864		in one formula	Se7/0/0.12/2:1
Sheet8

 

[I2omani]

Here's my attempt at reverse formula:

Excel Workbook
	A	B	C	D	E	F	G	H
1	*	Group 4	Group 5	Group 6	Group 7	*	initial string =	864-2
2	1	817	829	841	853	*	*	*
3	2	818	830	842	854	*	reverse ...	*
4	3	819	831	843	855	*	( starting with H1 cell )	*
5	4	820	832	844	856	*	get first part	864
6	5	821	833	845	857	*	get row in sheet	13
7	6	822	834	846	858	*	get col in sheet	5
8	7	823	835	847	859	*	Get group	Group 7
9	8	824	836	848	860	*	Make serial	Se7
10	9	825	837	849	861	*	Make card	12
11	10	826	838	850	862	*	Final result	Se7/0/0.12/2:1
12	11	827	839	851	863	*	*	*
13	12	828	840	852	864	*	in one formula	Se7/0/0.12/2:1
Sheet8

no working for me i keep getting #VALUE

 

[al_b_cnu]

Hi,

Have you tried my solution?

 

[GlennUK]

no working for me i keep getting #VALUE

All the numbers in cells in mine were actual numbers ... are yours text?

If you process the various stages you should see which bit is failing.

 

[GlennUK]

Hi,

Have you tried my solution?

... try al_b_cnu's solution ... if the number patterns match that logic it's a neat solution.