I have a formula that works without taking into account the blank cells when I'm trying to conduct a Textjoin() to obtain the adjacent row header when the cell in a row is filled.
The intended result would be:
example of the desired output:
I have a formula that works without looking at the blanks, what I need is when there is a blank cell the adjacent header is ignored.
Try the following formula-
To make it dynamic (automatically spill results) try-
You can easily find the file using ...READ MORE
If you have already registered for ...READ MORE
i want to link my logo to ...READ MORE
I'm trying to share a story with ...READ MORE
Hello, yes u can find your birthdate using ...READ MORE
Hi To Calculate the date, we can ...READ MORE
I having a Excel sheet with 1 ...READ MORE
In this case, you can use nested ...READ MORE
You can enter the following formula in ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.