Mar 05 2021 07:14 PM
Mar 06 2021 03:40 AM
Mar 06 2021 08:14 AM
Mar 06 2021 08:35 AM
Attached is the Excel workbook. :) Thank you for your help! @mathetes
Mar 07 2021 09:50 AM
Solution
I have started you on the road to getting the invoice that lists only the items for which a quantity has been entered on your Product Price List sheet. I used the new FILTER function, which will only work for you if you have the most current version of Excel. It is so powerful and easy to use that I highly recommend updating your system if you don't have that.
This does NOT address everything you asked for, but I think it gets at the most important part. I'd be happy to do more if you'd like.....but first take a look at this and what I've written both here and on the workbook itself. I did not try to make it a finished product; my goal was to introduce you to the FILTER function, which I think will go a long way toward resolving what you need. There still is work to do, however. But you clearly have learned a lot, even if you don't feel all that confident yet. And the best way to keep learning, is to keep working at it.
The other observation I'd make is that you have (in my opinion) made a classical mistake: you've worked to make your workbook "pretty" before developing the needed functionality. As a result, I was never able to get the FILTER function to work in your original Invoice sheet. I created the start of another. My recommendation is to get a workbook like this functioning first, then make it attractive to the eye. I'm leaving that last part to you.
A few additional recommendations:
Here is a link to a very useful video that Microsoft has created to introduce people to FILTER and some other new functions you might find useful. It's where I learned of these functions, in fact, just a few months ago. https://www.youtube.com/watch?v=9I9DtFOVPIg
Mar 08 2021 05:38 PM
It has been a remarkably busy couple days, so I am just now getting to this. Thank you so much for your time and help.
I am going to look more closely at what you have done and try and wrap my brain around what you have explained. I am excited to learn more of this and I will be watching the YouTube video you attached. Thank you for that!!
I pay monthly for Office 365 family, so I am not sure if it is the latest version. I do however see a fx (insert function) button on the far-left side of the ribbon under the formulas tab. Is this the button you are talking about?
Shirley Davis
Mar 09 2021 05:35 AM
Mar 07 2021 09:50 AM
Solution
I have started you on the road to getting the invoice that lists only the items for which a quantity has been entered on your Product Price List sheet. I used the new FILTER function, which will only work for you if you have the most current version of Excel. It is so powerful and easy to use that I highly recommend updating your system if you don't have that.
This does NOT address everything you asked for, but I think it gets at the most important part. I'd be happy to do more if you'd like.....but first take a look at this and what I've written both here and on the workbook itself. I did not try to make it a finished product; my goal was to introduce you to the FILTER function, which I think will go a long way toward resolving what you need. There still is work to do, however. But you clearly have learned a lot, even if you don't feel all that confident yet. And the best way to keep learning, is to keep working at it.
The other observation I'd make is that you have (in my opinion) made a classical mistake: you've worked to make your workbook "pretty" before developing the needed functionality. As a result, I was never able to get the FILTER function to work in your original Invoice sheet. I created the start of another. My recommendation is to get a workbook like this functioning first, then make it attractive to the eye. I'm leaving that last part to you.
A few additional recommendations:
Here is a link to a very useful video that Microsoft has created to introduce people to FILTER and some other new functions you might find useful. It's where I learned of these functions, in fact, just a few months ago. https://www.youtube.com/watch?v=9I9DtFOVPIg