Forum Discussion
Excel Help!
Here's the formula that gets those rows. You only enter it once, in cell A3...the results "Spill" into adjacent rows and columns. You DO need the most current version of Excel for this to work. SORT still needs to be added, but I haven't time.
=FILTER(STOCKLIST!A3:AZ21,(NOT(ISBLANK(STOCKLIST!Y3:Y21)))+(NOT(ISBLANK(STOCKLIST!Z3:Z21))))
And here's a video that explains how FILTER works. And the video explains SORT too, so incorporating it will be a good learning experience for you.
https://www.youtube.com/watch?v=9I9DtFOVPIg
P.S. I see you couldn't resist adding the aesthetic bells and whistles--fancy colors, vertical column headings, etc. That really is a mistake, because it can often get in the way of functionality. Save that, if it's even necessary, for the end. And only for the output sheets. You do not need it on the database itself.
