Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare data on two spreadsheets.
I am attempting to create a spreadsheet that can be used to show if an order
is complete. Some orders contain only one line and a simple IF statement tells me wheter or not a each line is complete, =IF(QTY ORDERED=QTY WRAPPED,"READY","NOT READY") but I am stumped in trying to compare multiple lines on one order. For example: Order 123456 Line 1 QTY ORDERED 5 QTY WRAPPED 5 STATUS READY Order 123456 Line 2 QTY ORDERED 4 QTY WRAPPED 3 STATUS NOT READY Order 654321 Line 1 QTY ORDERED 2 QTY WRAPPED 2 STATUS READY Order 654321 Line 2 QTY ORDERED 6 QTY WRAPPED 6 STATUS READY In the above example, I would like to return the information in Order 654321 to another spreadsheet indicating that all lines on the the order are complete and can be shipped. Hopefully this makes sense and someone can help me out. Thanks, DC James |
#2
|
|||
|
|||
You've got a response to try out in your later re-post in
..worksheet.functions -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "dcjames" wrote in message ... I am attempting to create a spreadsheet that can be used to show if an order is complete. Some orders contain only one line and a simple IF statement tells me wheter or not a each line is complete, =IF(QTY ORDERED=QTY WRAPPED,"READY","NOT READY") but I am stumped in trying to compare multiple lines on one order. For example: Order 123456 Line 1 QTY ORDERED 5 QTY WRAPPED 5 STATUS READY Order 123456 Line 2 QTY ORDERED 4 QTY WRAPPED 3 STATUS NOT READY Order 654321 Line 1 QTY ORDERED 2 QTY WRAPPED 2 STATUS READY Order 654321 Line 2 QTY ORDERED 6 QTY WRAPPED 6 STATUS READY In the above example, I would like to return the information in Order 654321 to another spreadsheet indicating that all lines on the the order are complete and can be shipped. Hopefully this makes sense and someone can help me out. Thanks, DC James |
#3
|
|||
|
|||
Thanks Max.
I really appreciate the assistance. Your solution seems to be working well. Thanks again, dcjames "Max" wrote: You've got a response to try out in your later re-post in ..worksheet.functions -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "dcjames" wrote in message ... I am attempting to create a spreadsheet that can be used to show if an order is complete. Some orders contain only one line and a simple IF statement tells me wheter or not a each line is complete, =IF(QTY ORDERED=QTY WRAPPED,"READY","NOT READY") but I am stumped in trying to compare multiple lines on one order. For example: Order 123456 Line 1 QTY ORDERED 5 QTY WRAPPED 5 STATUS READY Order 123456 Line 2 QTY ORDERED 4 QTY WRAPPED 3 STATUS NOT READY Order 654321 Line 1 QTY ORDERED 2 QTY WRAPPED 2 STATUS READY Order 654321 Line 2 QTY ORDERED 6 QTY WRAPPED 6 STATUS READY In the above example, I would like to return the information in Order 654321 to another spreadsheet indicating that all lines on the the order are complete and can be shipped. Hopefully this makes sense and someone can help me out. Thanks, DC James |
#4
|
|||
|
|||
Great to hear that !
Thanks for the feedback .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "dcjames" wrote in message ... Thanks Max. I really appreciate the assistance. Your solution seems to be working well. Thanks again, dcjames |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
how do I compare data in Exel spreadsheets? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How do I compare data in two different spreadsheets i.e. (column . | Excel Discussion (Misc queries) |