|
|
#4
03-20-2024, 04:48 PM
|
||||
|
||||
I can get it like this very easily (do you really need to keep the Concat column? and what does it contain anyway?):
2024-03-20_234208.jpg What version of Excel are you using? A workbook with your data would be very useful otherwise we're just guessing (probably wrongly) your setup. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Concatenating in an Array formula
|
Phil H | Excel | 6 | 02-25-2019 08:36 AM |
| Array formula value not available error for one result | emarkona | Excel | 1 | 03-08-2018 03:00 PM |
| Array Formula | Macacidic | Excel | 2 | 09-12-2017 08:19 AM |
|
Excel simplify formula - array of sequential numbers
|
Wries | Excel Programming | 1 | 05-12-2014 08:32 AM |
|
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |
Windows 10 
Office 2021
Threaded Mode