Extracting Numbers
Hello,
I have spreadsheet that shows the number of parts purchased by each customer - customer, PN, qty purchased. There is a second spreadsheet that shows the maximum order quantity for each item these customers can purchase. I want to know which stores went over the maximum order quantity for each item. The information is set up with all the customers in the first column, part numbers on the first row and the quantity purchased for each store below the part number. How do I compare and extract the information I need? Thank you, |
Extracting Numbers
Something like
=SUMIF(Sheet1!1:1,"Customer",Sheet1!3:3) perhaps -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... Hello, I have spreadsheet that shows the number of parts purchased by each customer - customer, PN, qty purchased. There is a second spreadsheet that shows the maximum order quantity for each item these customers can purchase. I want to know which stores went over the maximum order quantity for each item. The information is set up with all the customers in the first column, part numbers on the first row and the quantity purchased for each store below the part number. How do I compare and extract the information I need? Thank you, |
All times are GMT +1. The time now is 03:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com