Hi guys i'm now working on a spreadsheet and was wondering whether this is achievable by using excel basic formula:
I have created a databank for a list of item with their accordance price.
For Instance (Sheet1):
Cell A1=Item A = $8.00..........Quantity = 1
Cell A2=Item B = $13.00.........Quantity = 0
Cell A3=Item C = $18.00.........Quantity = 1
Cell A4=Item D = $23.00.........Quantity = 0
Let say Customer A would like to buy Item A and Item C only is there a way to display the final list as:
For example (Sheet 2):
Cell A1=Item A = $8.00..........Quantity = 1
Cell A2=Item C = $18.00.........Quantity = 1
**Item B and Item D will not be shown
I would like excel to automatic capture those item with quantity>1 only and arrange them in order.
Can anyone provide any idea on this?
Bookmarks