Hello Excel Experts and Wonderful Wizards,
I have an excel workbook attached here that "works" but the formulas need to be optimized, with your kind help.
The purpose of the workbook is save the Import Tabs as a CSV, but the way the workbook is set up, I have helper columns that I wish to exclude from CSV. I also have to use a combo of Filter + custom formula in SAME ROW, because I cannot "index" something >256 characters. It's clunky.
Workbook:
1 Data Tab = "Stories"
2 Import Tabs - "ImportT1" & "ImportJ1" - these tabs need to be saved as two CSV files, so I can import them into another program.
On the import Tabs, I have made a number of suggestions and queries - hope you can check them out and provide me with feedback!
Thank you, wizards, gurus!
Example Questions:
1 - Notice that Colums H - J do NOT use the Filter formula, because when I ask Excel to return data from Stories Tab, we max out at 256 characters with the filter formula, so I had to create an alternative formula! Any other solutions?
2 - This TAB needs to be saved as CSV so I can import it into another program…but I do NOT want Column A (Col A is Used only to obtain the ROW so I can get data in Columns H - J). I have tried to HIDE column A but row data appears when I save file as CSV. Col A is really only a helper column for Cols H - J
3 - I have to keep pulling down formula in Columns H - J -- is there any way we can create a formula that goes as far down as the data then stops
4 - Seems like my formulas are too big and complicated - can they be simplified?
CSV Issues
When I save as CSV - I do NOT want data from Column A, I also do not want a bunch of commans ,,,,,,,,,,,saved as CSV from pulling down the formula in Cols H - J
I have an excel workbook attached here that "works" but the formulas need to be optimized, with your kind help.
The purpose of the workbook is save the Import Tabs as a CSV, but the way the workbook is set up, I have helper columns that I wish to exclude from CSV. I also have to use a combo of Filter + custom formula in SAME ROW, because I cannot "index" something >256 characters. It's clunky.
Workbook:
1 Data Tab = "Stories"
2 Import Tabs - "ImportT1" & "ImportJ1" - these tabs need to be saved as two CSV files, so I can import them into another program.
On the import Tabs, I have made a number of suggestions and queries - hope you can check them out and provide me with feedback!
Thank you, wizards, gurus!
Example Questions:
1 - Notice that Colums H - J do NOT use the Filter formula, because when I ask Excel to return data from Stories Tab, we max out at 256 characters with the filter formula, so I had to create an alternative formula! Any other solutions?
2 - This TAB needs to be saved as CSV so I can import it into another program…but I do NOT want Column A (Col A is Used only to obtain the ROW so I can get data in Columns H - J). I have tried to HIDE column A but row data appears when I save file as CSV. Col A is really only a helper column for Cols H - J
3 - I have to keep pulling down formula in Columns H - J -- is there any way we can create a formula that goes as far down as the data then stops
4 - Seems like my formulas are too big and complicated - can they be simplified?
CSV Issues
When I save as CSV - I do NOT want data from Column A, I also do not want a bunch of commans ,,,,,,,,,,,saved as CSV from pulling down the formula in Cols H - J
Attachments
Last edited: