This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've been trying a variety of multi-row formulas but can't quite figure this one out!
I've got a set of data that is made up of two tables, but with each new dataset the table can be of a varying number of rows. I've managed to flag where the table ends but now am unsure how to filter the top and bottom half so I'm left with two separate tables. I've been trying to use a multi-row formula to create a new filter column 1 and 0 to then use a filter tool to separate but cannot get the formula to work.