opkvital.blogg.se

Excel vba script
Excel vba script






This sample of code shows how array structured, need results like. If there duplicate id, there multiple instances of maximum value, want keep id, date, value value maximum value given id, seq minimum seq given id.īasically, each id want maximum value, if there multiple maximums, default earliest sequence number. If there duplicate id, need store id, seq, value value maximum value given id. If there no duplicate, need store id, seq, value. However, calculation step uses redim preserve have store array testarray(1 3, 1 6).

excel vba script excel vba script

resulting array contains id, 2 values: id seq value 1 100 2 150 3 200 b 1 10 b 2 10 b 3 10 At request of user, have rewritten question more information, tried clarify as possibly can.








Excel vba script