Construct all pairs with the difference of or distances = 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,21,22,23,24 , 25

[piter]

Construct all pairs with the difference of or distances = 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,21,22,23,24 , 25
From the beginning of 01 to 80
Example = distance of 4
04 08
08 12
12 16
(I.e.
Up until
76-80
Another example distance of = 12
05 17
17 29
......
Up to 78 to 80
Put on an excel sheet

 

[BrianJN1]

Copy the formulae into the appropriate cells and drag down. Then change the value in B1 to whatever your difference is to be.

Excel 2013/2016
	A	B
1	Difference	6
2	6	12
3	12	18
4	18	24
Sheet1

Cell Formulas
Range	Formula
A2	=B1
A3	=A2+$B$1
B2	=A2+$B$1
B3	=A3+$B$1

Or were you seeking something else?

 

[piter]

Olá, você está correto! Eu tentei colocá-lo em uma folha de excel. Eu não fiz isso
De notar todas as formações de 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25
Um exemplo de diferença 25
02 27 = diferença 25
65 80 = 25
Obtenha em uma folha de excel! Por favor

 

[BrianJN1]

Olá, você está correto! Eu tentei colocá-lo em uma folha de excel. Eu não fiz isso
De notar todas as formações de 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25
Um exemplo de diferença 25
02 27 = diferença 25
65 80 = 25
Obtenha em uma folha de excel! Por favor

Piter this section is for English only, there is another for different languages;
Anyway I've used an on-line Portuguese/English service and have

Hello, you are correct! I tried to put it in a leaf of excel. I did not do that
Of noticing all the formations of 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25
An example of difference 25
02 27 = distinguishes 25
65 80 = 25
Obtain in a leaf of excel! Please

By a Leaf in Excel I seem to understand that you want one formula, maybe something like SUMPRODUCT, and then drag that down?
I don't know how to do that, but if that is so then advise and someone should be able to assist.

 

[Marcelo Branco]

Maybe something like this

Enter the distance in E1

Formula in A2 (English)
=IF(OR(ROWS(A$2:A2)>80,ROWS(A$2:A2)+E$1>80),"",ROWS(A$2:A2))

(Portuguese - BR)
=SE(OU(LINS(A$2:A2)>80;LINS(A$2:A2)+E$1>80);"";LINS(A$2:A2))

Formula in B2 (English)
=IF(A2="","",A2+E$1)

(Portuguese - BR)
=SE(A2="";"";A2+E$1)

Select A2:B2 and copy (drag) down till row 81


[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]

A​

[/TD]
[TD="bgcolor: #DCE6F1"]

B​

[/TD]
[TD="bgcolor: #DCE6F1"]

C​

[/TD]
[TD="bgcolor: #DCE6F1"]

D​

[/TD]
[TD="bgcolor: #DCE6F1"]

E​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

1
​

[/TD]
[TD]

Lower​

[/TD]
[TD]

Higher​

[/TD]
[TD][/TD]
[TD]

Distance​

[/TD]
[TD]

4​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

5​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

3​

[/TD]
[TD]

2​

[/TD]
[TD]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

4​

[/TD]
[TD]

3​

[/TD]
[TD]

7​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

5
​

[/TD]
[TD]

4​

[/TD]
[TD]

8​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

6​

[/TD]
[TD]

5​

[/TD]
[TD]

9​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

7
​

[/TD]
[TD]

6​

[/TD]
[TD]

10​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

8​

[/TD]
[TD]

7​

[/TD]
[TD]

11​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

9​

[/TD]
[TD]

8​

[/TD]
[TD]

12​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

10​

[/TD]
[TD]

9​

[/TD]
[TD]

13​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

11​

[/TD]
[TD]

10​

[/TD]
[TD]

14​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

12​

[/TD]
[TD]

11​

[/TD]
[TD]

15​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

13
​

[/TD]
[TD]

12​

[/TD]
[TD]

16​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

14​

[/TD]
[TD]

13​

[/TD]
[TD]

17​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

15​

[/TD]
[TD]

14​

[/TD]
[TD]

18​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

16​

[/TD]
[TD]

15​

[/TD]
[TD]

19​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

17​

[/TD]
[TD]

16​

[/TD]
[TD]

20​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

18​

[/TD]
[TD]

17​

[/TD]
[TD]

21​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

19
​

[/TD]
[TD]

18​

[/TD]
[TD]

22​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

20
​

[/TD]
[TD]

19​

[/TD]
[TD]

23​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

21​

[/TD]
[TD]

20​

[/TD]
[TD]

24​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

22​

[/TD]
[TD]

21​

[/TD]
[TD]

25​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

23​

[/TD]
[TD]

22​

[/TD]
[TD]

26​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

24
​

[/TD]
[TD]

23​

[/TD]
[TD]

27​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

25
​

[/TD]
[TD]

24​

[/TD]
[TD]

28​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

26​

[/TD]
[TD]

25​

[/TD]
[TD]

29​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

27​

[/TD]
[TD]

26​

[/TD]
[TD]

30​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

28​

[/TD]
[TD]

27​

[/TD]
[TD]

31​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

29​

[/TD]
[TD]

28​

[/TD]
[TD]

32​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

30
​

[/TD]
[TD]

29​

[/TD]
[TD]

33​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

31
​

[/TD]
[TD]

30​

[/TD]
[TD]

34​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

32​

[/TD]
[TD]

31​

[/TD]
[TD]

35​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

33​

[/TD]
[TD]

32​

[/TD]
[TD]

36​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

34​

[/TD]
[TD]

33​

[/TD]
[TD]

37​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

35​

[/TD]
[TD]

34​

[/TD]
[TD]

38​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

36
​

[/TD]
[TD]

35​

[/TD]
[TD]

39​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

37
​

[/TD]
[TD]

36​

[/TD]
[TD]

40​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

38​

[/TD]
[TD]

37​

[/TD]
[TD]

41​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

39​

[/TD]
[TD]

38​

[/TD]
[TD]

42​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

40​

[/TD]
[TD]

39​

[/TD]
[TD]

43​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

41​

[/TD]
[TD]

40​

[/TD]
[TD]

44​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

42​

[/TD]
[TD]

41​

[/TD]
[TD]

45​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

43
​

[/TD]
[TD]

42​

[/TD]
[TD]

46​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

44
​

[/TD]
[TD]

43​

[/TD]
[TD]

47​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

45​

[/TD]
[TD]

44​

[/TD]
[TD]

48​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

46​

[/TD]
[TD]

45​

[/TD]
[TD]

49​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

47​

[/TD]
[TD]

46​

[/TD]
[TD]

50​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

48​

[/TD]
[TD]

47​

[/TD]
[TD]

51​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

49​

[/TD]
[TD]

48​

[/TD]
[TD]

52​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

50​

[/TD]
[TD]

49​

[/TD]
[TD]

53​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

51
​

[/TD]
[TD]

50​

[/TD]
[TD]

54​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

52
​

[/TD]
[TD]

51​

[/TD]
[TD]

55​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

53​

[/TD]
[TD]

52​

[/TD]
[TD]

56​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

54​

[/TD]
[TD]

53​

[/TD]
[TD]

57​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

55​

[/TD]
[TD]

54​

[/TD]
[TD]

58​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

56​

[/TD]
[TD]

55​

[/TD]
[TD]

59​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

57
​

[/TD]
[TD]

56​

[/TD]
[TD]

60​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

58
​

[/TD]
[TD]

57​

[/TD]
[TD]

61​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

59​

[/TD]
[TD]

58​

[/TD]
[TD]

62​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

60​

[/TD]
[TD]

59​

[/TD]
[TD]

63​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

61​

[/TD]
[TD]

60​

[/TD]
[TD]

64​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

62​

[/TD]
[TD]

61​

[/TD]
[TD]

65​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

63
​

[/TD]
[TD]

62​

[/TD]
[TD]

66​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

64
​

[/TD]
[TD]

63​

[/TD]
[TD]

67​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

65​

[/TD]
[TD]

64​

[/TD]
[TD]

68​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

66​

[/TD]
[TD]

65​

[/TD]
[TD]

69​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

67​

[/TD]
[TD]

66​

[/TD]
[TD]

70​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

68​

[/TD]
[TD]

67​

[/TD]
[TD]

71​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

69
​

[/TD]
[TD]

68​

[/TD]
[TD]

72​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

70
​

[/TD]
[TD]

69​

[/TD]
[TD]

73​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

71​

[/TD]
[TD]

70​

[/TD]
[TD]

74​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

72​

[/TD]
[TD]

71​

[/TD]
[TD]

75​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

73​

[/TD]
[TD]

72​

[/TD]
[TD]

76​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

74​

[/TD]
[TD]

73​

[/TD]
[TD]

77​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

75
​

[/TD]
[TD]

74​

[/TD]
[TD]

78​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

76
​

[/TD]
[TD]

75​

[/TD]
[TD]

79​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

77​

[/TD]
[TD]

76​

[/TD]
[TD]

80​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

78​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

79​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

80​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

81
​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


M.

 

[piter]

ok marcelo thank you

 

[Marcelo Branco]

piter

You are welcome

M.