|
|
#1
02-21-2019, 06:57 AM
|
|||
|
|||
Concatenating in an Array formula
How to concatenate " (24%) " into this array formula?
{="After-Tax Balance " & TEXT(INDEX(AH:AH,MAX(IF(AH5:AH200="",FALSE,ROW(AH5 :AH200)))), "$#,##0")} Result now is: After-Tax Balance $100 Desired: After-Tax Balance $100 (24%) 
|
| Tags |
| array, concatenate |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 |
|
Convert String Array to Integer Array from a User Input?
|
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
|
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |
Windows XP 
Office 2010 64bit
Threaded Mode