Thank you so much for doing a tutorial on this after my question on your last video. Your content is very well produced and easy to follow. I can't thank you enough. Keep up the good work.
Thank you so much for your kind words! I'm really glad to hear that you found the tutorial helpful and easy to follow. Your feedback means a lot to me and motivates me to keep creating content. If you have any more questions or topics you'd like me to cover, feel free to let me know. Thanks again for your support!
Could I ask if we could get more information at a glance on Sheet 1 that would show in the next column "how much the difference in stock is" and perhaps "How much is in stock on sheet 2 (the warehouse)". This would make stock checking easier when say sheet 2 has more entries and in a different order, to save searching back and forth. Thank you so much for all your help an making these tutorial's so easy to follow.
You can add more information directly on Sheet1 to make stock checking easier. Here's how: 1. In the next column, you can display the stock from Sheet2 (the warehouse) using this formula: =INDEX(Sheet2!C:C, MATCH(B2, Sheet2!B:B, 0)). 2. In another column, you can calculate the stock difference between Sheet1 and Sheet2 with this formula: =C2 - D2. This way, you can easily see how much stock is in the warehouse and the difference, even if Sheet2 has more entries or is in a different order. Thanks again for your kind words!
Can I ask if it would be possible to extend the formula to check the two lists (sheets) by the product code before highlighting the quantity differences. An example being the lists are in a different order, not match-able due to more items on the warehouse sheet? Thank you again.
Yes, it's definitely possible to extend the formula to check the two lists by the product code before highlighting quantity differences! Simply use the MATCH function to find the corresponding product code in Sheet2 and then use the INDEX function to retrieve the quantity. Here's how you can do it: 1. Select the quantity range on Sheet1. 2. Go to Home > Conditional Formatting > New Rule. 3. Use the formula =C2INDEX(Sheet2!C:C, MATCH(B2, Sheet2!B:B, 0)) to highlight differences. This way, you can accurately compare quantities even if the lists are in different orders. Let me know if you have any further questions!
![เป็นไปได้ไหม - WanMai [Official MV]](http://i.ytimg.com/vi/_6lZ6b3_7Vo/mqdefault.jpg)
Thank you so much for doing a tutorial on this after my question on your last video. Your content is very well produced and easy to follow. I can't thank you enough. Keep up the good work.
Thank you so much for your kind words! I'm really glad to hear that you found the tutorial helpful and easy to follow. Your feedback means a lot to me and motivates me to keep creating content. If you have any more questions or topics you'd like me to cover, feel free to let me know. Thanks again for your support!
Could I ask if we could get more information at a glance on Sheet 1 that would show in the next column "how much the difference in stock is" and perhaps "How much is in stock on sheet 2 (the warehouse)". This would make stock checking easier when say sheet 2 has more entries and in a different order, to save searching back and forth. Thank you so much for all your help an making these tutorial's so easy to follow.
You can add more information directly on Sheet1 to make stock checking easier. Here's how:
1. In the next column, you can display the stock from Sheet2 (the warehouse) using this formula: =INDEX(Sheet2!C:C, MATCH(B2, Sheet2!B:B, 0)).
2. In another column, you can calculate the stock difference between Sheet1 and Sheet2 with this formula: =C2 - D2.
This way, you can easily see how much stock is in the warehouse and the difference, even if Sheet2 has more entries or is in a different order.
Thanks again for your kind words!
@@ExcelWithBrainBell Thank you so much, the formulas work a treat! Keep up the good work 👍
Can I ask if it would be possible to extend the formula to check the two lists (sheets) by the product code before highlighting the quantity differences. An example being the lists are in a different order, not match-able due to more items on the warehouse sheet? Thank you again.
Yes, it's definitely possible to extend the formula to check the two lists by the product code before highlighting quantity differences! Simply use the MATCH function to find the corresponding product code in Sheet2 and then use the INDEX function to retrieve the quantity. Here's how you can do it:
1. Select the quantity range on Sheet1.
2. Go to Home > Conditional Formatting > New Rule.
3. Use the formula =C2INDEX(Sheet2!C:C, MATCH(B2, Sheet2!B:B, 0)) to highlight differences.
This way, you can accurately compare quantities even if the lists are in different orders. Let me know if you have any further questions!