Multi row formula query **urgent

Question

Pretty Urgent

I have attached sample 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

In original data set basically assume 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?

query 22.xlsx

multirow 1.PNG

multirow 2.PNG

ed_hayter · Answer

A suggestion if you want this solved.

I have read this a couple of times and really cannot grasp what you are trying to do.

It seems you are suggesting that your actual data is also different to the mock data you have provided.

I think rather than uploading mock data where everything is null except the value you want you make a smaller dataset that actually looks like what you have where we can then think of some logic that scales up to larger data.