mehmetd
New Member
- Joined
- Dec 12, 2012
- Messages
- 1
Mr. Hello friends.
I have a request from you. Can you help me how to do the operation with the following function using VBA code?
=_xlfn.CHOOSEROWS(_xlfn.CHOOSECOLS(SORT(FILTER(LIST!A2:H2000;( FROM LEFT(LIST!A2:A2000;3)="120")*(LIST!F2:F2000>=J1)*(LIST! F2:F2000<=J2)*(LIST!H2:H2000<>0)*(LIST!I2:I2000=1));8;-1);1;2;5;6;8);ROW(1 :100))
I have a request from you. Can you help me how to do the operation with the following function using VBA code?
=_xlfn.CHOOSEROWS(_xlfn.CHOOSECOLS(SORT(FILTER(LIST!A2:H2000;( FROM LEFT(LIST!A2:A2000;3)="120")*(LIST!F2:F2000>=J1)*(LIST! F2:F2000<=J2)*(LIST!H2:H2000<>0)*(LIST!I2:I2000=1));8;-1);1;2;5;6;8);ROW(1 :100))