Excel VBA Diagonal Sorting -
good day! image attached contains sorting want data. vba code this?
the code use is:
for b = 1 30 if < 2 cells(b, a).value = 1 = + 1 else cells(b, a).value = 1 = 1 end if next b
it can sort 2 rows before resets. how expand 1 in image? thanks!
like this:
for b = 1 30 = 1 3 if = 1 cells(b, a).value = 1 elseif = 2 cells(b, a).value = 1 else cells(b, a).value = 1 end if next next b
Comments
Post a Comment