ADVERTISEMENT

Zliczanie_par-1.xls

Excel VBA - Jak zliczyć wspólne wartości z komórek AI i AJ w tablicy A1:AD10?

Włącz makra, wciśnij ctrl + Q Sprawdź czy o to chodziło


Download file - link to post

" P1_K " , " P2_1 " , " P3_2015 " , " P4_E " , " P5_S " , " P6_NW " , " P7_Medycyna " , " P8_B " , " P9_A " , " P9_B " , " P9_D " , " P10_G " , " P11_B " , " P11_D " , " P12_A " , " P13_N " , " P14_N " , " P21_0 " , " P22_B " , " P22_C " , " P23_D " , " P23_G " ,,,,,,,,,,,,, " P1_K " , " P2_1 " ,,
" P1_K " , " P2_1 " , " P3_2015 " , " P4_E " , " P5_S " , " P6_NW " , " P7_Prawo " , " P8_C " , " P9_A " , " P9_B " , " P9_D " , " P10_G " , " P11_B " , " P11_D " , " P12_A " , " P13_N " , " P14_N " , " P21_0 " , " P22_B " , " P22_C " , " P23_A " , " P23_D " , " P23_G " ,,,,,,,,,,,, " P1_K " , " P3_2015 " ,,
" P1_K " , " P2_1 " , " P3_2015 " , " P4_E " , " P5_S " , " P6_NW " , " P7_NW " , " P8_C " , " P9_A " , " P9_B " , " P9_D " , " P10_G " , " P11_B " , " P12_A " , " P13_N " , " P14_N " , " P21_0 " , " P22_B " , " P22_C " , " P22_D " , " P23_A " , " P23_D " , " P23_G " , " P23_H " ,,,,,,,,,,, " P1_K " , " P4_E " ,,
" P1_M " , " P2_1 " , " P3_2016 " , " P4_E " , " P5_S " , " P6_N " , " P7_Elektrotechnika " , " P8_B " , " P9_B " , " P9_C " , " P9_D " , " P10_C " , " P11_B " , " P12_A " , " P13_T " , " P14_N " , " P21_0 " , " P22_B " , " P22_C " , " P22_D " , " P23_A " , " P23_D " , " P23_F " , " P23_G " , " P23_H " ,,,,,,,,,, " P1_K " , " P5_S " ,,
" P1_M " , " P2_1 " , " P3_2015 " , " P4_E " , " P5_S " , " P6_N " , " P7_Elektrotechnika " , " P8_A " , " P9_A " , " P9_D " , " P10_C " , " P11_A " , " P11_B " , " P12_A " , " P12_D " , " P13_T " , " P14_N " , " P21_0 " , " P22_C " , " P23_A " , " P23_D " , " P23_G " ,,,,,,,,,,,,, " P1_K " , " P6_NW " ,,
" P1_M " , " P2_1 " , " P3_2015 " , " P4_E " , " P5_N " , " P6_T " , " P7_NW " , " P8_C " , " P9_A " , " P9_B " , " P9_C " , " P9_D " , " P10_C " , " P10_D " , " P10_E " , " P11_A " , " P11_C " , " P11_D " , " P12_A " , " P12_C " , " P12_D " , " P13_T " , " P14_T " , " P15_D " , " P16_36 " , " P17_B " , " P18_B " , " P19_C " , " P20_C " , " P21_0 " ,,,,, " P1_K " , " P7_Medycyna " ,,
" P1_K " , " P2_1 " , " P3_2015 " , " P4_E " , " P5_N " , " P6_T " , " P7_NW " , " P8_D " , " P9_A " , " P9_B " , " P9_C " , " P9_D " , " P10_G " , " P11_A " , " P12_A " , " P12_D " , " P13_T " , " P14_T " , " P15_D " , " P16_28 " , " P17_B " , " P18_D " , " P19_D " , " P20_D " , " P21_0 " ,,,,,,,,,, " P1_K " , " P8_B " ,,
" P1_K " , " P2_1 " , " P3_2016 " , " P4_E " , " P5_N " , " P6_T " , " P7_NW " , " P8_C " , " P9_B " , " P10_G " , " P11_A " , " P11_D " , " P12_A " , " P12_D " , " P13_T " , " P14_T " , " P15_D " , " P16_48 " , " P17_B " , " P18_B " , " P19_A " , " P20_C " , " P21_0 " ,,,,,,,,,,,, " P1_K " , " P9_A " ,,
" P1_K " , " P2_1 " , " P3_2015 " , " P4_Z " , " P5_S " , " P6_NW " , " P7_NW " , " P8_B " , " P9_B " , " P9_C " , " P9_D " , " P10_G " , " P11_F " , " P12_A " , " P13_T " , " P14_T " , " P15_G " , " P16_30 " , " P17_C " , " P18_H " , " P19_D " , " P20_A " , " P21_0 " ,,,,,,,,,,,, " P1_K " , " P9_B " ,,
" P1_K " , " P2_1 " , " P3_2015 " , " P4_Z " , " P5_S " , " P6_NW " , " P7_NW " , " P8_A " , " P9_D " , " P10_G " , " P11_F " , " P12_A " , " P12_D " , " P13_T " , " P14_N " , " P21_0 " , " P22_E " , " P23_D " , " P23_G " , " P23_H " ,,,,,,,,,,,,,,, " P1_K " , " P9_D " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P10_G " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P11_B " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P11_D " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P12_A " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P13_N " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P14_N " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P21_0 " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P22_B " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P22_C " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P23_D " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P23_G " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P7_Prawo " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P8_C " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P23_A " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P7_NW " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P22_D " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P23_H " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P1_M " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P3_2016 " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P6_N " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P7_Elektrotechnika " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P9_C " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P10_C " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P13_T " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P23_F " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P8_A " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P11_A " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P12_D " ,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, " P1_K " , " P5_N " ,,