hello,
i don't think this is very complicated, but apparently i'm not the excel expert.

so, i have 2 tables on the same worksheet. on the first table i have a list of subjects, each one with 80 lines. and on the second table i have only 1 line for each subject.
1. i need to apply a function at the beginning of every 80 rows ex: G02, G82, G162.....
2. the second thing is that i need to calculate only the first 40 rows of each subject.

thanks !