Forum Discussion
Question related to Excel formula
Hello Everyone, If letter "e" is entered in row C10:H16 or below, then cell C5:H5 appears listed separated by a comma, depending where "e" is. Also the formula needs to extend if new column or row a...
Another approach using FILTER()
=TEXTJOIN(", ",TRUE,
FILTER(TRANSPOSE($C$5:$H$5),TRANSPOSE(C10:H10)="e",""))
Or
=TEXTJOIN(", ",TRUE,
FILTER($C$5:$H$5,(C10:H10="e")*(COLUMN($C$5:$H$5))>0,""))
FILTER FUNCTION not there in my office version. Because i am using Microsoft Office 2019 Home and Student version.
Sir, is there another way to solve?
Please..??
- Thank you so much sir