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.
Formula for Flash Fill Inconsistent Non-Empty Cells
-
- Lounger
- Posts: 41
- Joined: 13 Feb 2024, 09:41
Formula for Flash Fill Inconsistent Non-Empty Cells
You do not have the required permissions to view the files attached to this post.
-
- 5StarLounger
- Posts: 826
- Joined: 24 Jan 2010, 15:56
Re: Formula for Flash Fill Inconsistent Non-Empty Cells
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.
=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
Rory
-
- Lounger
- Posts: 41
- Joined: 13 Feb 2024, 09:41
Re: Formula for Flash Fill Inconsistent Non-Empty Cells
Thank you, Roy.
Tested it, and it worked.
Tested it, and it worked.