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...
The following will work in Excel in Office 2019, Office 2021 and Microsoft 365.
In J10:
=TEXTJOIN(", ",TRUE,IF($C10:$H10="e",$C$5:$H$5,""))
If you have Office 2019, confirm the formula with Ctrl+Shift+Enter.
Then fill down.
Thank you so much sir...