Multi row formula

[Meghnagupta]

I have attached screenshot of data in Alteryx. I want to pick value from cell 172 which is entirely null.

Mean 'FDIC Certificate Number:' Row number 166+6 row is required.

I want my courser in +6 every time.

Can someone help on this? 

[mceleavey]

Hi @Meghnagupta ,

I'm sorry, I don't really understand the logic here. Can you post the data (mock is fine) and show us what you want to see? 

M.

[Raj]

Please explain the logic

As much i understood you want row no from were null rows are available and how many rows are available .

Is this something you are looking at?

[Meghnagupta]

@raj basically think that i have a data in row number 172 in column F22. But there is no header to it in that row where i can put filter on.

So, I am thinking if we can pick a text value from above row and use multi row formula in it and pick row172. Further remove nulls so that i can get value in F22 column.

I don't want to hard code it by using select record.

If i am able to explain myself?

[Raj]

@Meghnagupta 
can you please share some input and required output table so i can help you create the logic
i understand you want to make it dynamic.

[Meghnagupta]

@Raj  : I have attached dataset

I want to pick value 9899999 from row 171

Main excel sheet has various value. I have tried below using multi row formula but result is giving '0' in row 166

if ([f1] = 'qwrewyu' and [New] = 'qwrewyu') then [Row+6:F1] = 'qwrewyu' else [F1] endif