Forum Discussion
ldcrooks
Apr 20, 2021Copper Contributor
Excel Help!
Hi there, I was wondering if anyone could help me - we are moving all from Google sheets over onto Excel and my head is gone. I have used Google Sheets for that long I can't get something simple ...
ldcrooks
Apr 21, 2021Copper Contributor
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.
mathetes
Apr 21, 2021Silver Contributor
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.