I am struggling to learn / utilize some of the new Excel 2021 formulas. I also might not be thinking of the best way to solve my problem. See description below and attached.
I have 3 columns of interest (A, B, and Q). With lots of data in between and rows occurring irregularly. Is there a way to filter columns of interest with data? So, for example, column A might be my column of the "most interest"....how would I write a formula to get A, B, Q all extracted separately?
Bookmarks