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 have a 1000 row excel workbook with multiple sections on the same sheet, each with a unique header. Each section has exactly 16 rows of data included. I want to pull the rows only from one specific header called "wages".
I tried using a multi-row formula and the below expression to pull only these 16 rows but it isnt working. Any ideas?
IF Contains([F1], "Wages", 1)
THEN [Row+1:Test]+1 & THEN [Row+2:Test]+1 & THEN [Row+3:Test]+1 & (... all the way to +16)
You could use a formula to add in another field when the column header contains 'Wages', then a multi-row formula to start once the 'Wages' field is located, to carry down the 'Wages' annotation until another header is located (or a counter until 16 is reached); then filter out everything that doesn't have the new 'Wages'/counter annotations.
Try something like this... Use the Multi-Row formula tool to categorize each row by seeing if the current row has a value in column F1. if it does, it will copy that value into a new field this creates call "section". on rows where there's no value found, it copies the "section" value from the previous row... essentially filling down until a new a new value is found. Afterwards, use a Filter tool to only keep the rows filled with "wages".
Here's the expression in the MR formula tool.