Feb 06 2023 12:09 PM
I'm trying to create a backwards formula (extraction):
That will find the attribute (column name)in a All Columns value (based on data in a created formula.)
For example,
Column 1 Column 2 Column 3 Column 4 All Columns Backward Formula Extraction
25 feet. 2 towels Black No value 2 Towels, Black Column 1, Column 2, Column 3, Column 4
Feb 07 2023 03:04 PM
Feb 07 2023 05:20 PM
Feb 07 2023 06:13 PM
Feb 13 2023 05:12 AM
Feb 13 2023 06:10 AM
@williamdhicks ok if you can't attach an actual sheet you can upload to onedrive, sharepoint, or similar and share a link or PM it directly to me. At the least you can use the 'full editor' here, hit the 3 dots (...) and then insert a table
so we can read what you are trying to show.
That all said I think I might know what you want and here is a formula to try:
=TEXTJOIN(",",1,FILTER($A$1:$H$1,($A2:$H2<>"")*ISNUMBER(SEARCH($A2:$H2,$I2))))
The columns are A:H and the paragraph is in I. IF any column with something in it will be in the final paragraph then you only need the ($A2:$H2<>"") part. This will join the column headers ($A$1:$H$1) in a comma delineated list but you could change that to use what ever you want. Regardless you will need to parse that list in a formula to 'recreate' that paragraph (i.e. even if the text in the cell is designed to be the exact formula needed to recreate the paragraph Excel doesn't support an EVAL() command to execute that text for safety reasons.
See attached.