Forum Discussion
Excel Help!
Back to basics now. Have some sample data in the Stocklist Tab.
For the 'HOLD/SOLD TRACKER' would it be possible just to bring across just the rows that have info in the "24 hour hold by" or "Sold by" columns from the Stock Tab, sorted by the "Expected Delivery Date" Column?
Thanks so much for your 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.