Use new FILTER() formula and retrieve only the columns you want
So my jaw just dropped when I recently saw this video from the never boring Microsoft MVP Oz du Soleil, who shows us you can select only the columns you want. Wow! This means a process in Excel (whether done manually or via VBA) can indeed now be done within an Excel FILTER formula. For me in my work this is huge. I have since added a draft of the formula to my AHK (Auto Hot Key https://www.autohotkey.com/ ) as “FilterX” which is my equivalent of “that’s going straight to the pool room” aka Darryl Kerrigan from the quirky Aussie comedy film The Castle . If you don’t use AHK, it’s great for generating auto replace text and script base shortcuts which works across all PC software. But you could also enter this into Excel’s autocorrect.
So here is the formula in Oz’s video modified by me a bit.
Basically it’s selecting 6 columns A,B,H,C,E & F for the rows 2:93 if D2:D93=whats in M11 (which can be a dropdown). But the main point is it’s returning 6 selected column A,B,H,C,E & F in the order I want.
Anyway watch the entertaining Oz explain this and enjoy!