I want to get purchase qty in issue qty column where there is tran type is sale or trfr(transfer) in way that issue qty not exceed purchase qty for particular item code.
also keep in mind where purch entry is there in tran type column, issue qty should be zero in the same row.
i want to get issue qty by formula in Column D. The desired result to get from formula is shown in column F.
thanks in advance.
D2, copied down:
=IF(A2<>"purc",SUM(C$2:C2)-SUM(D$1:D1),0)
see file.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
thanks Glenn for your quick response.Originally Posted by Glenn Kennedy
if i sort the data with column A this condition failed please keep the keyword ie. item code (in column B) in formula.
Last edited by db; 12-22-2023 at 08:03 AM.
You should have said that you wanted to sort the data in the first post.
Attach a file showing what you mean by sorting.
I guess what OP's want is in D2 and copy down.
Please Login or Register to view this content.
dear all,
sorry for the delay response. this time please find the revised sheet with adding new date column(sort by column A and then Column B). my query is same.
I want to get purchase qty in issue qty column where there is tran type is sale or trfr(transfer) in way that issue qty not exceed purchase qty for particular item code.
also keep in mind where purch entry is there in tran type column, issue qty should be zero in the same row.
i want to get issue qty by formula in Column D. The desired result to get from formula is shown in column F.
Regards,
Try this in E2 and copy down.
Please Login or Register to view this content.
thanks windknife, it works for me.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks