Hi all!
I m a newbie here.. I have some Excel problems which I couldn't solve, hope to get help here..
Pls see attached excel sheets.
Thanks guys!
Rgds,
CK
Hi all!
I m a newbie here.. I have some Excel problems which I couldn't solve, hope to get help here..
Pls see attached excel sheets.
Thanks guys!
Rgds,
CK
Last edited by kiong234; 11-17-2012 at 04:13 AM.
Hi kiong234
You will need to rename your thread title , to something a bit more meaningful.
Have a look here: Forum Rules
Hi, kiong234
pls mention your problem in Thread Titles.
Regards,
Nandkumar Satpute
Thanks guys! Title changed, hope to get more attention and helps..
^^
Hi,
I have checked your file but can you be clearer. If i change the filter on dates, the formulas don't change.
Thx. to be more exact.
Thanks Mase723!
It's because, without sorting the data from oldest dates to latest dates with same product code in one group, i can't allocate by FIFO without a helpful formula..
I still don't know how to do it now.. So, I use manual checking on dates to allocate correctly on Alloc Qty #2.. but then, this is not efficient when i have to do it for more than 4000+ lines of data..
^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks