in a1= student name,b1= student scor
a2:a100.value = jack2..until jack100 ,in b2:b100.value = 100,80,90 ....until range(b100)
i want copy by criteria in col B 3 top skor (first scor,second scor,third scor) to column(d)..it is posible if use vba array
how to apply worksheetFunction.large to arrayPlease Login or Register to view this content.
Bookmarks