Forum Discussion
Identical Excel formula = Different results in PowerQuery
Hi, I am a bit confused about this. I have an identical formula in 2 different, but comparable Excel Workbooks. The formula is as follows TEXTJOIN("-";TRUE;C12:L12) Howe,ver when loadin...
You say the Excel workbooks are different, but comparable. How comparable? Both .xlsx? Both formulas in tables? Any named ranges in one and not the other? Any missing values that are causing the #NAME error?
Hi,
Thank you for your interest and response.
- Comparabale as completely identical in terms of structure, and formatting, but values of cells in documents may differ
- Both files are .xlsx
- Source data is not structured in tables but simply Excel cells
- No named ranges in either document referring to the affected cells
- Identical formula across documents resultign in a textstring (TEXTJOIN-formula) in Excel