Formula for Flash Fill Inconsistent Non-Empty Cells

Eng mona
Lounger
Posts: 41
Joined: 13 Feb 2024, 09:41

Formula for Flash Fill Inconsistent Non-Empty Cells

Post by Eng mona »

I have a very long extended sheet ( the attached is a small copy of it)

I have some NA blank cells in column F. I need to fill these columns with the text join of the details in the cells after it. (till the following empty cells)

The number of non-empty cells after every NA cell in column F is inconsistent.

Can anyone please help adjust a formula to flash-fill the NZ cells for inconsistent non-empty cells?

If I learn how to do this function, I will use it in column D, but this time to have the sum of the non-empty cells. And so on.

Many thanks in advance for any help.
You do not have the required permissions to view the files attached to this post.

User avatar
rory
5StarLounger
Posts: 826
Joined: 24 Jan 2010, 15:56

Re: Formula for Flash Fill Inconsistent Non-Empty Cells

Post by rory »

You could use:
=IF(F2="N/A",TEXTJOIN(",",TRUE,FILTER(F2:F17,(A2:A17=A2)*(B2:B17=B2)*(F2:F17<>"N/A"))),F2)
assuming you have the relevant functions available in your version.
Regards,
Rory

Eng mona
Lounger
Posts: 41
Joined: 13 Feb 2024, 09:41

Re: Formula for Flash Fill Inconsistent Non-Empty Cells

Post by Eng mona »

Thank you, Roy.

Tested it, and it worked.