please separate the threes and make a difference in the number one with the last .

[jack]

please separate the threes and
make a difference in the number one with the last of each trio, eg = 02 05 09 = 02-09 = 7
* center number9 05) does not enter the study
the difference is between the first number with the last one
* of each trio
http://www.mediafire.com/file/zrm8zz7s1f4k4ug/diferan%25C3%25A7a_dos_trios.xlsx/file

 

[jack]

That said, here's how I would build that spreadsheet -- without any VBA:

0) Starting with columns A:O
1) In Q6, enter =A6 and copy/paste/fill into Q6:AE6
2) Select column AC and insert column. Repeat for column Z, W, T.
3) In the newly created empty column T, enter =S6-Q6. Copy T6 and paste into X6, AB6, AF6, AJ6
4) To get the summary table off to the right, AM6 =T6, AN6 =X6, AO6 =AB6, AP6 =AF6, AQ6 =AJ6.
5) Select Q6:AQ6 and copy/paste/fill down.

 

[jack]

please need to enable the above formula in the spreadsheet

 

[Frank]

That said, here's how I would build that spreadsheet -- without any VBA:

0) Starting with columns A:O
1) In Q6, enter =A6 and copy/paste/fill into Q6:AE6
2) Select column AC and insert column. Repeat for column Z, W, T.
3) In the newly created empty column T, enter =S6-Q6. Copy T6 and paste into X6, AB6, AF6, AJ6
4) To get the summary table off to the right, AM6 =T6, AN6 =X6, AO6 =AB6, AP6 =AF6, AQ6 =AJ6.
5) Select Q6:AQ6 and copy/paste/fill down.

Nearly right

0) Starting with columns A:O
1) In Q6, enter =A6 and copy/paste/fill into Q6:AE6. correct
2) Select column T and insert column. Repeat for column (X,AB and AF).
3) In the newly created empty column T, enter =S6-Q6. Copy T6 and paste into X6, AB6, AF6, AJ6 correct
4) To get the summary table off to the right, AM6 =T6, AN6 =X6, AO6 =AB6, AP6 =AF6, AQ6 =AJ6. correct
5) Select Q6:AQ6 and copy/paste/fill down. correct

you just need to correct step 2.

You dont need anybody but yourself to activate it, Just DO IT!

Goodbye!

 

[jack]

ok frank thanks for viewing the post, my excel is in portuguese the formula has to be in portuguese?
or in english also works in excel in portuguese?
how to translate to portuguese? please

 

[Frank]

You are not using any advanced Excel functions. Just arithmetic operations. I’m sure a plus + is a plus and a minus - is a minus and an equal = is an equal in most languages.
Dont be afraid to experiment. Your computer won’t explode if it doesn’t work. You learn by trial and error.

Did you know you can build up a formula by clicking in cells instead of typing the cell address?

Example click in empty cell T6
type =
click in cell S6
type -
click in cell Q6
Hit Enter key

creates formula =S6-Q6 in cell T6

 

[Frank]

https://www.excel-function-translation.com/index.php?page=english-portuguese.html

 

[jack]

ok FRANK thank you!