how to solve a problem in exel?

[Bojan1994]

Hi,
How to automatically get the results for the column "number of movements of passenger cars in a good hour"?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: how to solve a problem in exel? [SOLVED]
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Bojan1994]

how to delete this post

 

[Fluff]

No need to delete it, we just ask that if you cross post in future, you let us know.

 

[BSALV]

you want excel to find the shortest way or less movements from point A to point B , a kind of Google Maps ?

 

[Bojan1994]

how to send you a gif file and exel table

 

[Bojan1994]

 

[BSALV]

At this moment, nobody understands the question, so this is also a guess.
In a module you create an UDF and in the worksheet you call that UDF with the content of a cell

Function Eval(c)
     Application.Volatile
     Eval = Evaluate("=" & c) '---> evaluate that string
End Function

to je tacno 1.2 (1).xlsx
	A	B	C
1	1-e	175+175+88+175	613
2	e-1	1070+835+301+329	2535
3	e-t	175+175+921+135	1406
4	t-e	1070+329+428+267	2094
5	t-2	175+921+135	1231
6	2-t	1070+428+428+267	2193
7	e-I	175	175
8	I-e	835	835
9	I-a	175	175
10	a-I	835	835
11	a-3	175	175
12	3-a	835	835
13	1-r	123+88+105+88+221+35+140+158	958
14	r-1	1227+148+364+247+170+90	2246
15	r-n	123+105+88+428	744
16	n-r	1227+221+921	2369
17	n-4	123+428	551
18	4-n	1227+921	2148
19	e-b	88+428+267	783
20	b-e	301+135	436
21	b-5	88+428	516
22	5-b	301+135	436
23	r-l	88+140	228
24	l-r	148+170	318
25	l-ć	88+140+267	495
Sheet1

Cell Formulas
Range	Formula
C1:C25	C1	=eval(B1)

 

[Bojan1994]

From table to je tacno 15.1 first see the data (5-b) it has a value of 60. Then in the second table to je tacno 4.1 search (5-b) and assign a value in column B

 

[Bojan1994]

Next from table tacno 15.1 we see the data (b-e) it has the value 60, then in the second table to je tacno 4.1 it is searched (b-e) and the value is assigned in B column 60