Hi benishiryo,
Just found out that the formula return value form the bottom to top. Is there any way to search the value from top to bottom or I have to sort value from small to larger.
To ensure the formula work correct I would like to matches the third column and please look at revise-sample in attached.
Regards,
tt3
Regards,
tt3
Last edited by tuongtu3; 10-17-2013 at 11:00 AM.
Hi benishiryo,
Just found out that the formula does not get result when qty does not match. Please take a look at cell W3 and W16 in attached file.
Regards,
tt3
Maybe conditions of the data rather ambiguous? "cell W16 should be 1" Why?Originally Posted by tuongtu3
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks