Find Interval Number Based On Adjacent Cell

[muhammad susanto]

hi guys..

i'm looking for excel formula to find the interval number based on adjacent column (in left)
like table below :

	data given	data given	4
data entry	cumulative sum	expected result (interval)
9	9	9-13
13	13	14-17
15	17	18-21
23	21	22-25
34	25	etc..

<tbody>
</tbody>

any help, much appreciated..

m.susanto

 

[AliGW]

Explain the results, please - how are you calculating them?

 

[gaz_chops]

Not sure! Try

=B3+1&"-"&B4

[/COLOR][/FONT][/COLOR]
[TABLE="width: 325"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]data entry[/TD]
[TD]cumulative sum[/TD]
[TD="colspan: 2"]expected result (interval)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]Sep-13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD]14-17[/TD]
[TD][/TD]
[TD]14-17[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD]18-21[/TD]
[TD][/TD]
[TD]18-21[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]21[/TD]
[TD]22-25[/TD]
[TD][/TD]
[TD]22-25[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]25[/TD]
[TD]etc..[/TD]
[TD][/TD]
[TD]26-[/TD]
[/TR]
</tbody>[/TABLE]
[COLOR=#000000][FONT=Lucida Grande][COLOR=#006107]

 

[muhammad susanto]

Not sure! Try

=B3+1&"-"&B4

[TABLE="width: 325"]
<tbody>[TR]
[TD]data entry[/TD]
[TD]cumulative sum[/TD]
[TD="colspan: 2"]expected result (interval)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]Sep-13
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD]14-17[/TD]
[TD][/TD]
[TD]14-17[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]17[/TD]
[TD]18-21[/TD]
[TD][/TD]
[TD]18-21[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]21[/TD]
[TD]22-25[/TD]
[TD][/TD]
[TD]22-25[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]25[/TD]
[TD]etc..[/TD]
[TD][/TD]
[TD]26-[/TD]
[/TR]
</tbody>[/TABLE]

not fully working in start lowest number the should be still 9-13 the next is ok from 14-17....
sorry i'm typo in 9 number

 

[AliGW]

ADVERTISEMENT

Explain the logic, please.

 

[muhammad susanto]

sorry, my interval is 4 start from 9.
first target should be :
9-13
14-18
19-23
etc....

 

[AliGW]

ADVERTISEMENT

OK - that makes sense, but to me, your expected results don't. How have you arrived at those, please?

 

[gaz_chops]

Yes, doesn't seem consistant.

 

[muhammad susanto]

hi Gaz, have you great idea, i need your help...

 

[AliGW]

Gaz and I need your answers to my questions if either of us is going to be able to help. Your data is inconsistent.