Hi
Please help in finding the excel VB code OR formula for the above enclosed.
I have master data with different days were i require to pickup 3 , 3 , 3, nnnn with average equal or near to master data.
Note : you have a unique value as CHQ NUMBER
Cheq Amt CHQ NUMBER CHEQUE DATES CURRENT DATE DAYS
218295 1111 2-May-16 21-Mar-2016 42
218295 2222 4-May-16 21-Mar-2016 44
218295 3333 5-May-16 21-Mar-2016 45
218295 4444 8-May-16 21-Mar-2016 48
218295 5555 9-May-16 21-Mar-2016 49
218295 6666 10-May-16 21-Mar-2016 50
5730.24 7777 11-May-16 21-Mar-2016 51
39690 8888 7-May-16 21-Mar-2016 47
----------------------------------------------------------------------------
SPLIT TOTAL AVG 47.0
-----------------------------------------------------------------------------
Automation Required as below
-----------------
Average |Splitting into 3 | Cheq Amt
----------- ---------------- -----------------------
47 42 48 51 218295 218295 5730.24
47 44 50 47 218295 218295 39690
47 45 49 218295 218295
Regards
PSN
Bookmarks