|
|
#3
10-24-2020, 10:23 PM
|
|||
|
|||
How are you getting the data into excel? Power query or a simple copy and paste?
Attched i have done a power query version, using the second plus as a delimiter (couldnt get it to delimit on the line feed, but i am no expert) - this should be able to be refreshed daily when the new data is availible. the Second sheet is the text to columns version - probably the most simple, just insert a column and text to columns the third sheet is using formulas. this is possible but when i copied and pasted the data i got a few different formats, i dont know why but it would take a few ifs to get it right. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LOOKUP Formula error but WHY??? | Haga | Excel | 1 | 04-17-2019 11:13 PM |
 Entering a column value in a cell, to be used as part of a reference in a formula in another cell
|
paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
| Error handling in formula - suppress 'Syntax Error' | Cosmo | Word | 7 | 02-24-2014 07:08 AM |
|
Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
Windows 10 
Office 2019
Threaded Mode