Forum Discussion
Mindi_B44839
Jun 08, 2022Copper Contributor
Converting Google to Excel help
Hello, My work just made us switch from Google to Microsoft. One of our main documents we use is a Google Sheet that is huge and interactive. The Master sheet has columns A-AZ or more and most of ...
Patrick2788
Jun 08, 2022Silver Contributor
This might work (My sample master is 7 rows. Extend it as needed).
=INDEX(FILTER(Master!A1:AB7,Master!AN1:AN7=TRUE()),SEQUENCE(4),{1,2,28,4,5,10,7,8})
Sample workbook attached.