xl2bb reports same formula in 3 different cells

[JenniferMurphy]

In the mini-sheet below, xl2bb mistakenly reports the expressions in C3 & K3 as being the same as the one in G3. I show the correct expressions in C11, C12, & C13.

Tables.xlsx
	B	C	D	E	F	G	H	I	J	K	L
3	Name	Table1			Name	Table3			Name	Table99
4		#N/A
5
6	Name	Len	Wid		Name	Len	Wid		Name	Len	Wid
7	A	25	10		A	25	10		A	25	10
8	B	30	25		B	30	25		B	30	25
9	C	15	10		C	15	10		C	15	10
10
11		"C3: =MID(FORMULATEXT(B3),2,FIND("[",FORMULATEXT(B3))-2)"
12		"G3: =MID(FORMULATEXT(F3),2,FIND("[",FORMULATEXT(F3))-2)"
13		"K3: =MID(FORMULATEXT(J3),2,FIND("[",FORMULATEXT(J3))-2)"
Table Name

Cell Formulas
Range	Formula
B3	B3	=Table1[[#Headers],[Name]]
F3	F3	=Table3[[#Headers],[Name]]
G3,C3,K3	G3	=MID(FORMULATEXT(F3),2,FIND("[",FORMULATEXT(F3))-2)
J3	J3	=Table99[[#Headers],[Name]]
C4	C4	=MID(FORMULATEXT(Table1[[#Headers],[Name]]),2,FIND("[",FORMULATEXT(Table1[[#Headers],[Name]]))-2)

 

[Peter_SSs]

xl2bb mistakenly reports the expressions in C3 & K3 as being the same as the one in G3.

It isn't a mistake. If you take any of those 3 formulas and copy/paste to the other 2 cells the formulas become exactly what you have in those cells.

Consider this example. Would it really help understanding and/or the look of the forum if XL2BB listed 90 different formulas below the mini sheet instead of just the 3 formulas that are then copied to the other listed cells?

24 02 20.xlsm
	A	B	C	D
21	1	2	5	7
22	2	4	7	11
23	3	6	9	15
24	4	8	11	19
25	5	10	13	23
26	6	12	15	27
27	7	14	17	31
28	8	16	19	35
29	9	18	21	39
30	10	20	23	43
31	11	22	25	47
32	12	24	27	51
33	13	26	29	55
34	14	28	31	59
35	15	30	33	63
36	16	32	35	67
37	17	34	37	71
38	18	36	39	75
39	19	38	41	79
40	20	40	43	83
41	21	42	45	87
42	22	44	47	91
43	23	46	49	95
44	24	48	51	99
45	25	50	53	103
46	26	52	55	107
47	27	54	57	111
48	28	56	59	115
49	29	58	61	119
50	30	60	63	123
Sheet5

Cell Formulas
Range	Formula
B21:B50	B21	=A21*2
C21:C50	C21	=B21+3
D21:D50	D21	=C21+B21

 

[JenniferMurphy]

Hmmm... Ok, I see your point. Is there a reason that it picked G3, the one in the middle, as the one to report (cite?), rather than C3, the one on the left?

 

[Peter_SSs]

Is there a reason that it picked G3

Not that I am aware of. I don't see it as an issue since all the formulas are the same (in that they all take the text from character 2 up the the character before the first "[" in the formula of the cell immediately to the left of the formula cell)